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

[0] Message Index

[#] Next page

There was an error while thanking
Thanking...
Go to full version
Powered by SMFPacks Advanced Attachments Uploader Mod