General > General Technical Chat
Excel scientific number
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
[0] Message Index
[#] Next page
Go to full version