| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to change scientific representation
I have column where numbers are in fact bandwidths of routers, for example
1866000 which I want to represent as 1.87 Mb, 1866000000 should be represented as 1.87 Gb, 186600000 should be represented as 187 Mb or 0.187 Gb etc. Please help with a macro to accomplish this. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to change scientific representation
You could use custom number formats of
0,," Mb" and 0,,," Gb" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Farooq Sheri" wrote: I have column where numbers are in fact bandwidths of routers, for example 1866000 which I want to represent as 1.87 Mb, 1866000000 should be represented as 1.87 Gb, 186600000 should be represented as 187 Mb or 0.187 Gb etc. Please help with a macro to accomplish this. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color representation of employee work hrs | New Users to Excel | |||
| Multiple Data Representation on Graphs | Excel Discussion (Misc queries) | |||
| change scientific notation (exponential) back to text | Excel Discussion (Misc queries) | |||
| Graphical Representation | Excel Discussion (Misc queries) | |||
| Excel 2003 won't let me change Xlabels from scientific notation | Charts and Charting in Excel | |||
Linear Mode
