Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. | Microsoft Word Help | |||
1st word in heading flush left second word flush right | New Users | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
creating forms | Microsoft Word Help | |||
Table headers | New Users |