Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change decimal answers in excel to the power of
I want to be able to change decimal answers in excel to the power of, e.g.:
0.006 to 6 x10-3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change decimal answers in excel to the power of
Rosco,
Try this: Format-Cells. In the Number tab, Category list, select Custom. Then enter for Type: 0 "x10 "E+0 There doesn't seem to be a way to get rid of the "E" though. "Rosco" wrote: I want to be able to change decimal answers in excel to the power of, e.g.: 0.006 to 6 x10-3 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change decimal answers in excel to the power of
format the cells to scientific
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Rosco" wrote: I want to be able to change decimal answers in excel to the power of, e.g.: 0.006 to 6 x10-3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change a decimal into seconds | Excel Worksheet Functions | |||
Cannot a change a number 10.0 to 10 , cannot take out the decimal | Excel Discussion (Misc queries) | |||
Excel ActiveX Scrollbar - change from integer to decimal | Excel Discussion (Misc queries) | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) |