| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
decimal spaces toolong when mail merging from excel
It works. I tried.
"punkyh" wrote: Thank you for the quick response! I have done this and it still doesn't work. "Peo Sjoblom" wrote: Try toolsoptionscalculations and select precision as displayed before doing the mailmerge -- Regards, Peo Sjoblom "punkyh" wrote in message ... I recive data in an excel spreadsheet that contains in one column a number expressed as " 5.55" which is supposed to be a percentage, but when I try to mailmerge the data, it mailmerges as "5.55061561650660". In other words it carries out the decimal place more than 2 digits, which is not what I want. I have tried formatting the cell, rounding, hand typing the information in another column and deleting the column that contained the original information (which I am sure was edited from 5.55061561650660.) How can I fix this problem so that when I mail merge it comes out as "5.55" only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal place and merging to word doc. | Excel Worksheet Functions | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| Mail Merging Help Needed. Quickly! | Excel Discussion (Misc queries) | |||
| Mail Merging a Table | Excel Discussion (Misc queries) | |||
Hybrid Mode
