Menu
I have a value in a cell that's in bytes. But nobody can read 728398112238. I'd rather it say 678.37GB
To write a formula to format it relatively easy (here's one: http://www.yonahruss.com/2007/02/format-excel-numbers-as-gb-mb-kb-b.html)
But is there any way to do this as a 'format'? I'd like to have the big number in the cell, but have it display as the human-readable format.
958
In other words, if you want to convert a storage size from bytes to MB, you need to divide it with 102 * 1024. Similarly, to convert it to GB, you need to divide it by 1024 * 1024 * 1024. What is this? Conversely, if you want to convert back, you need to multiply the storage size by 1024 each time.
If you want to convert mb to kb, just apply this formula: =A2*1024. Unit Conversion: (Convert between multiple units, such as time, distance, bits & bytes, etc. ) With Kutools for Excel's Unit Conversion utility, you can quickly convert between multiple units without any formulas.
Select the cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want.
You can't really do calculations in the formatting features of Excel. You can use something like the following to do a rough estimation though:
[<500000]#,##0" B";[<500000000]#,##0,," MB";#,##0,,," GB" If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
