G Glenn Dec 10, 2006 #1 How can I format a column so that it shows a number as kilobytes or gigabytes? Thanks.
B Bob Phillips Dec 10, 2006 #2 Format it as #,##0"Kb" -- --- HTH Bob (change the xxxx to gmail if mailing direct)
C Chip Pearson Dec 10, 2006 #3 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)
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)
D David McRitchie Dec 11, 2006 #4 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. Click to expand...
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. Click to expand...
