Number formatting

  • Thread starter Thread starter bfd
  • Start date Start date
B

bfd

does anyone know how to make an xl spread sheet display
numbers in engineering scientific notation in which the
powers 10 is raised is always in multiples of 3.

10^3, 10^6, 10^9 or 10^-3, 10^-6, 10^-9.
 
Is it real numbers or just for display?
If the latter

=10&"^"&ROW(1:1)*3

copied down will return 10^3, 10^6 and so on

and

=10&"^"&ROW(1:1)*-3
 
Format/Cells/Number/Custom ##0E+0

bfd said:
does anyone know how to make an xl spread sheet display
numbers in engineering scientific notation in which the
powers 10 is raised is always in multiples of 3.

10^3, 10^6, 10^9 or 10^-3, 10^-6, 10^-9.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers from first column 5
lookup functions 1
insert row when sum of values equals 100 2
Count Numbers 12
Custom cell format for Scientific Notation 4
Macro to add numbers in a text string 5
Conditional formatting dates 2
ARRAY with countif 6

Back
Top