There are multiple posts online explaining that you can click on a cell and use the Format > Number dropdown to change a cell's number to scientific notation.

However, my cell contains a mixture of text and numbers. Is there a function which would format something like

="This asteroid is " & SCI_NOTATION(A1) & " kilograms"


  • Welcome to Web Applications Please add some sample data and the expected results. P.S. Google Sheets several features that help to find built-in functions, i.e. the Help menu has a link to list of functions. It will be nice if you show what you have tried and if you include a brief description of your search efforts as is suggested in How to Ask. Oct 12, 2022 at 15:33

1 Answer 1



= "This asteroid is " & text(A1, "0.00E+00") & " kilograms."

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.