excel number help

  • Thread starter Thread starter mark27
  • Start date Start date
M

mark27

How do I format the cell to show only scientific numbers; i.e

0.01 x 10-6
0.001 x 10-6
1 x 10-6


Thank you

Mark
 
How do I format the cell to show only scientific numbers; i.e

0.01 x 10-6
0.001 x 10-6
1 x 10-6


Thank you

Mark
Click to expand...

Format/Cells/Number/Scientific and select the number of decimal places.


--ron
 

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

combining several lists into one? 1
Reference to another worksheet cell in a sumproduct formula 1
Conditional formula - dealing with < numbers as numeric fields 1
What makes people want to buy this NetBook 2
Custom cell format for Scientific Notation 4
Conditional Rounding 7
How to programme this in excel? 5
Logical 5

Back
Top