Here is a great tip for formatting numbers in Excel as Gigabytes, Megabytes, Kilobytes, Bytes, etc. Use the following formula: =IF((A1>=POWER(2,30)), TEXT((A1/POWER(2,30)),”##0.00\G”), IF((A1>=POWER(2,20)), TEXT((A1/POWER(2,20)),”##0.00\M”), IF((A1>=1024), TEXT((A1/1024),”##0.00\K”), TEXT((A1),”##0.00\B”) ) ) ) The same formula will work for Gigabits, Megabits, etc. assuming you start with bits instead of bytes. If you want to convert from bits…