[Peter Jamieson]

Try leaving the # character out of the format, e.g.

{ Price \#,0.0 }

Peter Jamieson

http://tips.pjmsn.me.uk

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!