Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy B
 
Posts: n/a
Default Getting currency formatting to fill in final 0

Quick question... I'm doing a mail merge from Excel for currency amounts.
When the data merges, I can get it formated to currency and to 2 decimal
places. The one piece that is outstanding, is when there is only 1 number
after the decimal point, instead of adding a 0, it does not show 2
characters.
so... if the amount is $340.20
what it's bringing up is: $340.2
I'm thinking there must be a formating parameter that I'm missing???
Appreciate any ideas you might have - thanks in advance for your help!
--
Cindy B
 
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
Currency formatting MarkN Microsoft Word Help 7 January 19th 06 09:56 AM
Final and Final Mark Up Lyte (from NYC) Microsoft Word Help 1 May 5th 05 12:02 AM
Word 2003: track changes opens in final view instead of final sho. JenniferLee Microsoft Word Help 2 April 19th 05 06:25 PM
Form Fields lose bold formatting Ellen Microsoft Word Help 0 February 17th 05 09:11 PM
Apply Style but keep direct formatting? Stefan Blom New Users 2 November 28th 04 11:30 PM


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

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

About Us

"It's about Microsoft Word"