If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge is dropping zeros after decimal
I am merging from excel into Publisher using the mail merge. However, when I
put in the field that has a price instead of merging like 79.10 it gives me 79.1. Does anyone know a work around. I am not talented enough to figure out how to stop this. |
#2
|
|||
|
|||
Merge is dropping zeros after decimal
Heather L wrote:
I am merging from excel into Publisher using the mail merge. However, when I put in the field that has a price instead of merging like 79.10 it gives me 79.1. Does anyone know a work around. I am not talented enough to figure out how to stop this. Either copy the data into a text field, or export the workbook as a CSV. Publisher tends to disrespect Excel's cell formatting. -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org |
Thread Tools | |
Display Modes | |
|
|