disk storage number format in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HDD disk formatted by Linux. How to check it? 3
Excell 2021 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Time Sum in Excel 1
Default number format in Excel 1
assign occurence number 3
can't get excel to calculate 1
Convert number to text as displayed 3

Back
Top