Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display all values as x.xxx+06?
I have a worksheet that is used by our group and many values are filled in
that are in that range of 10e4 or 10e5. For purposes of comparison, we would like all entries to display as 10e6 in the worsheet. Is there a way to format the cells so that when we enter a number like 12400, it will display as 0.0124e6? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display all values as x.xxx+06?
One way:
0.0000,,"e6" Does that work for you? Fred "Annette" wrote in message ... I have a worksheet that is used by our group and many values are filled in that are in that range of 10e4 or 10e5. For purposes of comparison, we would like all entries to display as 10e6 in the worsheet. Is there a way to format the cells so that when we enter a number like 12400, it will display as 0.0124e6? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display values between two dates | Excel Discussion (Misc queries) | |||
Display values set in a range?? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Do not display Zero values | Charts and Charting in Excel | |||
How to display zero values? | Excel Worksheet Functions |