Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I am doing a simple mailmerge from data in excel, when i merge a field
contains amount with 2 decimal point, it appear in word with 13 decimals. Example: 2,848.99 in excel data field after merge to word, it appeared as 2849.9899999999998 Can anyone teach me how to make it to appear same as excel format? Thanks in advance Cyin |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Press Alt+F9 to toggle on the display of the field codes and insert the
following formatting switch inside the closing } \# ",0.00" For more information, 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 "cyin" wrote in message ... I am doing a simple mailmerge from data in excel, when i merge a field contains amount with 2 decimal point, it appear in word with 13 decimals. Example: 2,848.99 in excel data field after merge to word, it appeared as 2849.9899999999998 Can anyone teach me how to make it to appear same as excel format? Thanks in advance Cyin |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a mail merged numbers print decimals to 2 places? | Mailmerge | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
mail merge keeps putting in decimals that are not on excel sheet | Mailmerge | |||
Amount decimals control | Mailmerge | |||
How do I keep mail merged numbers to two decimals | Mailmerge |