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
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
Original article here
Here's a simple trick:
Format the column with a custom setting and paste this in the format
Original article here
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment