| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with excel - how do get only 2 decimal places after com
I merge the excel data into the word. I have one column that contains numbers
from a formular and should show 2 decimal places after the comma but in word it shows 5 or 6. No matter how I format that field - I tried currency, accounting ... no change! The formular in the cell is =H68*167 - something I can change with the formular so it only shows 2 places after the comma??? Please help! |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
mail merge with excel - how do get only 2 decimal places after com
Looked thru the old posts and found my answer - thanks so much
"Kerstin" wrote: I merge the excel data into the word. I have one column that contains numbers from a formular and should show 2 decimal places after the comma but in word it shows 5 or 6. No matter how I format that field - I tried currency, accounting ... no change! The formular in the cell is =H68*167 - something I can change with the formular so it only shows 2 places after the comma??? Please help! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round numbers to 2 decimal places when using Word Mail Merge | Mailmerge | |||
| Limit the number of decimal places shown when I merge Excel-Word | Mailmerge | |||
| Unwanted decimal places in a mail merge from Excel | Mailmerge | |||
| Limit decimal places in mail merge document | Mailmerge | |||
| Mail merge prints out incorrect no. of decimal places from Excel . | Mailmerge | |||
Linear Mode
