Wednesday, February 5, 2014

Format Excel Column for Size in GB

Today I was doing some reporting on file sizes and saw that I had columns with data in bytes. When you are looking at the length in gigabytes it can get kinda crazy.
Here's a simple trick:
Format the column with a custom setting and paste this in the format
[<500000]#,##0" B ";[<500000000]#,##0,," MB";#,##0,,," GB"

Original article here