Number formatting

Viking08 · Mar 2nd, 2004, 09:20 PM

I need a the follwing number 181,000 to show as 181 but be valued as 181,000. Is there a way to do this. I need this format because this is the field that will balance out my report.

Thanks

Juan Pablo González · Mar 2nd, 2004, 09:21 PM

Try this format

#,##0,

yesterday · Mar 2nd, 2004, 09:25 PM

Even just
---> #, <---
would work.

The more commas you add, the more the number gets factored down by 1,000.

Seti · Mar 2nd, 2004, 10:03 PM

Yesterday's format will work if you don't need commas when you hit one million. Juan's will supply the commas so that 1,000,000 will show up as 1,000 rather than 1000.

Mar 2nd, 2004, 09:20 PM	#1
Viking08 Join Date: Feb 2004 Posts: 107	Number formatting I need a the follwing number 181,000 to show as 181 but be valued as 181,000. Is there a way to do this. I need this format because this is the field that will balance out my report. Thanks

Mar 2nd, 2004, 09:21 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,771	Re: Number formatting Try this format #,##0, __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 2nd, 2004, 09:25 PM	#3
yesterday Join Date: Mar 2003 Posts: 34	Re: Number formatting Even just ---> #, <--- would work. The more commas you add, the more the number gets factored down by 1,000.

Mar 2nd, 2004, 10:03 PM	#4
Seti Join Date: May 2002 Location: CT Posts: 2,877	Re: Number formatting Yesterday's format will work if you don't need commas when you hit one million. Juan's will supply the commas so that 1,000,000 will show up as 1,000 rather than 1000.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode