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