Numeric Formate

[dorothy]

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!

 

[Peter Jamieson]

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

{ Price \#,0.0 }

Peter Jamieson

http://tips.pjmsn.me.uk

 

[Graham Mayor]

Format it as
{Price \# ",0.00"}
or
{Price \# ",0.0"}
or
{Price \# "$,0.00"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[dorothy]

It works. Thank you!

Format it as
{Price \# ",0.00"}
or
{Price \# ",0.0"}
or
{Price \# "$,0.00"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>