I need make Number Format like scientific notation, but without E nor e. Just classic like this:
(In latex its 2.3\times10^3)
Maybe Excel doesn't support this format.
(I have on mind Number Format  for hundreds numbers  not in math formula)
I need make Number Format like scientific notation, but without E nor e. Just classic like this: (In latex its 2.3\times10^3) Maybe Excel doesn't support this format. (I have on mind Number Format  for hundreds numbers  not in math formula) 

migrated from stackoverflow.com Mar 29 '10 at 22:52This question came from our site for professional and enthusiast programmers. 


You could use html. Type this into Notepad
Copy it and, in Excel, Paste Special  Unicode. It will render whatever html you have. You won't be able to edit it in Excel though. 


Excel doesn't support that number format. I think you need to use a formula, like this:



Probably not the best location for this question, but these links might help: http://peltiertech.com/Excel/NumberFormats.html http://www.ozgrid.com/Excel/CustomFormats.htm I have used both sites as a reference when dealing with Excel stuff in the past. 

