Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
Excel cells should take number format and/or optional text eg Dec. | Excel Discussion (Misc queries) | |||
How do I change the default number format in excel? | Excel Worksheet Functions |