General > General Technical Chat
Excel scientific number
(1/3) > >>
geggi1:
Hi!
I'm working on a spreadsheet in excel with scientific numbers.
I would like to have the numbers following the SI way of numbering.
The numbers would go like this 1E3; 1E6; 1E9 the same way as Kilo, Mega, Giga.
Now i get these numbers in-between like 1E2; 1E5 and so on and it is a bit confusing.
Ian.M:
https://engineerexcel.com/engineering-notation-in-excel/
jpanhalt:

--- Quote ---Source: http://www.mathcentre.ac.uk/resources/uploaded/module1textbooklike.pdf
It is just a convention to put the decimal place after the first digit.

--- End quote ---

If you are just doing the math, I don't see the confusion.  There should be no confusion between numbers and units.  I don't believe my old version of Excel 2007 will do what you want.

Put another way, let's say you have a table of various things with a column labeled kg/m^3.  If the things range from lead to hydrogen, then the number part will cover quite a range of exponents, but the unit would remain the same.

For example (units = kg/m^3)*:
hydrogen: 8.98E-2
air          :1.20E0
water      :1.00E3
lead        :1.134E4

I would find that less confusing than changing to SI units for each entry.

*Source: https://en.wikipedia.org/wiki/Density
Ian.M:
The ##0.0E+0 custom number format from the link I gave works fine even in the truly antique Excel 97!  Unless Microsoft FUBARed number formatting when they introduced the ribbon UI, it should still work in Excel 2007
geggi1:
Thanks for your help this will work for me.
I'm working with Mohm and Gohm in my spreadsheet.
Navigation
Message Index
Next page
There was an error while thanking
Thanking...

Go to full version
Powered by SMFPacks Advanced Attachments Uploader Mod