[Dorothy]

It works. Thank you!

"Graham Mayor" wrote:

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!