disk storage number format in excel?
I am creating a sheet in excel to track disk usage, does anyone know of a way
to format the numbers in the cell to appear as common disk space nomenclature? I would like to see something like 54GB, 54k, 125mb.. |
disk storage number format in excel?
You can use Custom formatting, Right-click Format NumberTab Custom, and
in the small window type #"GB" OK, and for the next cell type #"k", and for the last #"mb"..then if you type 54 in the first cell, the result will be 54GB, and 54 in the second will return 54k and 125 in the third will return 125mb hth Vaya con Dios Chuck, CABGx3 "Mike Spalding" wrote: I am creating a sheet in excel to track disk usage, does anyone know of a way to format the numbers in the cell to appear as common disk space nomenclature? I would like to see something like 54GB, 54k, 125mb.. |
All times are GMT +1. The time now is 05:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com