Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Jim F.[_2_] Jim F.[_2_] is offline
external usenet poster
 
Posts: 1
Default Does anyone know how to use \# field switch for float $

I would like to format a merge field with a floating $. Example
mege filed content 123.45 should print $123.45, but if the content is 12.34
want to see $12.34 not $ 12.34.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default Does anyone know how to use \# field switch for float $

Try \# $#.##

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jim F." wrote in message
news
I would like to format a merge field with a floating $. Example
mege filed content 123.45 should print $123.45, but if the content is
12.34
want to see $12.34 not $ 12.34.


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Does anyone know how to use \# field switch for float $

Or if the sum runs into thousands ... or more

\# "$,0.00"

see http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Herb Tyson [MVP] wrote:
Try \# $#.##


"Jim F." wrote in message
news
I would like to format a merge field with a floating $. Example
mege filed content 123.45 should print $123.45, but if the content is
12.34
want to see $12.34 not $ 12.34.



  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default Does anyone know how to use \# field switch for float $

Always the optimist. ;-)

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Graham Mayor" wrote in message
...
Or if the sum runs into thousands ... or more

\# "$,0.00"

see http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Herb Tyson [MVP] wrote:
Try \# $#.##


"Jim F." wrote in message
news
I would like to format a merge field with a floating $. Example
mege filed content 123.45 should print $123.45, but if the content is
12.34
want to see $12.34 not $ 12.34.




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
Having a problem with a the TOC Field switch \b Mark Dullingham Page Layout 2 September 12th 08 02:30 AM
What is the field switch to display a SSN properly? James Ratner Microsoft Word Help 3 March 28th 08 11:47 AM
Database Field Switch scubadunc Mailmerge 1 March 28th 07 08:36 AM
How do I switch to the next form field? D. Prigmore Microsoft Word Help 3 December 28th 06 03:53 AM
CardText Field Switch JoyceA Mailmerge 2 June 18th 05 11:05 AM


All times are GMT +1. The time now is 03:52 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"