| 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 |