Format Excel numbers as GB, MB, KB, B
Here is a great tip for formatting numbers in Excel as Gigabytes, Megabytes, Kilobytes, Bytes, etc. Use the following formula:
excel
Excel: Automatically alternate row colors (dynamically)
This is a life saver. Although I hate to admit it, Microsoft Excel is the one of the IT Professional's Swiss Army Knives.