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 |
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 |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com