Custom format for displaying bytes as kb, mb, gb or tb.
Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc
Here is one that I have been using:
[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"
Briliant!
For those working with exa bytes, here is a modified @kaustubhcs' formula working all the way to zetta bytes. It also prints two decimal places. Replace B2 with your cell.
Base 1024
=IF(abs(B2)<1024, B2 & " B",
IF(abs(B2)<pow(1024, 2), ROUND(DIVIDE(B2,pow(1024, 1)),2) & " KiB",
IF(abs(B2)<pow(1024, 3), ROUND(DIVIDE(B2,pow(1024, 2)),2) & " MiB",
IF(abs(B2)<pow(1024, 4), ROUND(DIVIDE(B2,pow(1024, 3)),2) & " GiB",
IF(abs(B2)<pow(1024, 5), ROUND(DIVIDE(B2,pow(1024, 4)),2) & " TiB",
IF(abs(B2)<pow(1024, 6), ROUND(DIVIDE(B2,pow(1024, 5)),2) & " PiB",
IF(abs(B2)<pow(1024, 7), ROUND(DIVIDE(B2,pow(1024, 6)),2) & " EiB",
IF(abs(B2)<pow(1024, 8), ROUND(DIVIDE(B2,pow(1024, 7)),2) & " ZiB",
"Input is not a number"))))))))
Base 1000
=IF(abs(B2)<1000, B2 & " B",
IF(abs(B2)<pow(1000, 2), ROUND(DIVIDE(B2,pow(1000, 1)),2) & " KB",
IF(abs(B2)<pow(1000, 3), ROUND(DIVIDE(B2,pow(1000, 2)),2) & " MB",
IF(abs(B2)<pow(1000, 4), ROUND(DIVIDE(B2,pow(1000, 3)),2) & " GB",
IF(abs(B2)<pow(1000, 5), ROUND(DIVIDE(B2,pow(1000, 4)),2) & " TB",
IF(abs(B2)<pow(1000, 6), ROUND(DIVIDE(B2,pow(1000, 5)),2) & " PB",
IF(abs(B2)<pow(1000, 7), ROUND(DIVIDE(B2,pow(1000, 6)),2) & " EB",
IF(abs(B2)<pow(1000, 8), ROUND(DIVIDE(B2,pow(1000, 7)),2) & " ZB",
"Input is not a number"))))))))
super useful!