Tuesday, 31 May 2016

Simple GB Convertion in Excel

Format bytes a cell in Excel as KB, MB, GB etc?

Right click a particular cell, Format the cell and apply a Custom category and add to the 'Type' field [<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

works in office 2010 and above without any issues.