Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jeannie McQuaid
 
Posts: n/a
Default formatting numbers mail merged into Word table from an Excel Works

I have mail merged numerical values into a Word Table from an Excel
spreadsheet. In the Excel sheet, the values are set at 2 decimal points,
precision as displayed. Word however, trims trailing zeros, ie, 23.70
becomes 23.7. I need the trailing zeros, because the numbers are expressing
dollars and cents.
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Jeannie McQuaid" Jeannie wrote in
message ...
I have mail merged numerical values into a Word Table from an Excel
spreadsheet. In the Excel sheet, the values are set at 2 decimal points,
precision as displayed. Word however, trims trailing zeros, ie, 23.70
becomes 23.7. I need the trailing zeros, because the numbers are
expressing
dollars and cents.



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
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. Rachel King Microsoft Word Help 38 August 21st 09 09:54 PM
1st word in heading flush left second word flush right Elin New Users 9 April 4th 05 08:44 PM
Wordperfect Office 2000 conversion to Word 2003 MikeE New Users 1 March 21st 05 12:04 AM
creating forms Fluffypink Microsoft Word Help 4 March 9th 05 04:17 PM
Table headers Sam Hobbs New Users 12 December 20th 04 07:18 PM


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