macro to change scientific representation

  • Thread starter Thread starter Farooq Sheri
  • Start date Start date
F

Farooq Sheri

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where is my hard disk drive space?!?! 3
text converted to scientific notations 3
How to add up letters to equal a number value. 1
i want to convert decimals into time format 3
Merge /Update Macro 7
Formula to reference another cell in a worksheet 3
Formula to change scientific number to regular number or text 2
Conversion 7

Back
Top