#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dorothy Dorothy is offline
external usenet poster
 
Posts: 17
Default Numeric Formate

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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Numeric Formate

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!

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Numeric Formate

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!



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dorothy Dorothy is offline
external usenet poster
 
Posts: 17
Default 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!




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i use APA formate for an organization assesment Mayur Microsoft Word Help 0 April 16th 08 05:27 PM
formate of appointment letter to an accountant appointment letter Microsoft Word Help 1 April 13th 08 10:07 PM
Why bullet formate changes in same document on 2 PCs Ursula A. Microsoft Word Help 3 August 23rd 07 12:06 PM
Formate a Word hyperlink to an Excel worksheet LHSallwasser Microsoft Word Help 1 December 23rd 05 09:17 AM
Printing to pdf formate Ed C New Users 6 July 27th 05 08:01 AM


All times are GMT +1. The time now is 11:01 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"