Numeric Formate dorothy 12/22/2008 9:16:00 AM Hi, I want to display numeric numbers without spaces: e.g. 1) if Price < 1000, e.g. 12.3, then it is displayed as "12.3" 2) if Price >= 1000, e.g. 10003, it is displayed as "10,003" However, if I format is as : {Price \# ,##0.0} 1) will be displayed with spaces. e.g " 12.3" The only workaround I can think of is format it as : {IF {= Price / 100} < 0 "{Price \# 0.0}" "{Price \# ,##0.0}"} However this will make the file complexed as there are lots of "Prices" I have to buid in one file. Can anyone advise a solution? Thank you!

Re: Numeric Formate Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 12/22/2008 9:48:10 AM Try leaving the # character out of the format, e.g. { Price \#,0.0 } Peter Jamieson http://tips.pjmsn.me.uk dorothy wrote: [Quoted Text] > Hi, > > I want to display numeric numbers without spaces: > e.g. > > 1) if Price < 1000, e.g. 12.3, then it is displayed as "12.3" > 2) if Price >= 1000, e.g. 10003, it is displayed as "10,003" > > However, if I format is as : {Price \# ,##0.0} > 1) will be displayed with spaces. e.g " 12.3" > > The only workaround I can think of is format it as : > {IF {= Price / 100} < 0 "{Price \# 0.0}" "{Price \# ,##0.0}"} > > However this will make the file complexed as there are lots of "Prices" I > have to buid in one file. > > Can anyone advise a solution? > > Thank you!

Re: Numeric Formate "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/22/2008 9:54:51 AM Format it as {Price \# ",0.00"} or {Price \# ",0.0"} or {Price \# "$,0.00"} -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> dorothy wrote: [Quoted Text] > Hi, > > I want to display numeric numbers without spaces: > e.g. > > 1) if Price < 1000, e.g. 12.3, then it is displayed as "12.3" > 2) if Price >= 1000, e.g. 10003, it is displayed as "10,003" > > However, if I format is as : {Price \# ,##0.0} > 1) will be displayed with spaces. e.g " 12.3" > > The only workaround I can think of is format it as : > {IF {= Price / 100} < 0 "{Price \# 0.0}" "{Price \# ,##0.0}"} > > However this will make the file complexed as there are lots of > "Prices" I have to buid in one file. > > Can anyone advise a solution? > > Thank you!

Re: Numeric Formate dorothy 12/22/2008 10:48:00 AM It works. Thank you! "Graham Mayor" wrote: [Quoted Text] > Format it as > {Price \# ",0.00"} > or > {Price \# ",0.0"} > or > {Price \# "$,0.00"} > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > dorothy wrote: > > Hi, > > > > I want to display numeric numbers without spaces: > > e.g. > > > > 1) if Price < 1000, e.g. 12.3, then it is displayed as "12.3" > > 2) if Price >= 1000, e.g. 10003, it is displayed as "10,003" > > > > However, if I format is as : {Price \# ,##0.0} > > 1) will be displayed with spaces. e.g " 12.3" > > > > The only workaround I can think of is format it as : > > {IF {= Price / 100} < 0 "{Price \# 0.0}" "{Price \# ,##0.0}"} > > > > However this will make the file complexed as there are lots of > > "Prices" I have to buid in one file. > > > > Can anyone advise a solution? > > > > Thank you! > > >