• 0

Excel or GDocs - How to Convert between Unit KB to GB or 1000K to 1M.


Question

Is there any "Unit" function that allows it to show 1M whenever my number is 1000K or Higher.

Example 1000 = 1K, 1300 = 1.3K,

And if that number during the calculation equation goes up to 1000K it would auto change the unit to Million.

And something similar to KB, GB or TB?

Is that possible on Google Spreadsheet or Excel?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

In Excel, you can do part of this with a custom number format:

http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-number-format-HP001216503.aspx

A custom format of "#, k" would display 1000 as "1 k"

I'm not sure if what you want can be done using just formatting though, but if the number is returned as part of a formula you can add some extra logic to format it as desired using IF() and TEXT().

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.