Posted to microsoft.public.word.mailmerge.fields
|
|
Numeric Formate
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!
|