G
Glenn
How can I format a column so that it shows a number as kilobytes or
gigabytes?
Thanks.
gigabytes?
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Format it as #,##0"Kb"
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
C
Chip Pearson
Glenn,
Your question isn't very clear.
If you want to reduce the number of digits (e.g., displaying 1,000,000 as
1,000) use a custom number format of "0," or "0,," without the quotes.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
Your question isn't very clear.
If you want to reduce the number of digits (e.g., displaying 1,000,000 as
1,000) use a custom number format of "0," or "0,," without the quotes.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
D
David McRitchie
Or would it be multiples of 1024
Chip Pearson said:Glenn,
Your question isn't very clear.
If you want to reduce the number of digits (e.g., displaying 1,000,000 as
1,000) use a custom number format of "0," or "0,," without the quotes.