How can I format bytes a cell in Excel as KB MB GB etc

Question

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 is 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 displayed in a human-readable format.

Answer 1

In Excel's formatting features, computations are not actually possible. To make a ballpark estimate, you may use something like this:

[<500000]#,##0" B";[<500000000]#,##0,," MB";#,##0,,," GB"