merge: data losing formatting

C

cheekymama

I am merging from an Excel spreadsheet. Two of the three fields that contain
numbers formatted as currency are losing their formatting in the merge. All
three are formatted the same in the data source. Please help!
 
E

Ed Bennett

While in a state of ecstasy after repairing his laptop, Ed sees a
message from cheekymama said:
I am merging from an Excel spreadsheet. Two of the three fields that
contain numbers formatted as currency are losing their formatting in
the merge. All three are formatted the same in the data source.
Click to expand...

Try exporting your Excel spreadsheet as a CSV (comma separated values) file
and using that as your data source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Mail Merge - displaying a conditional number of decimals 5
ASK Field Formatting 1
Page numbering with Merged Document and IF statements 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
cannot find which label format i need 1
Converting URLs in comments to Markdown-formatted links 2
Mail Merge skipping records/sending one at a time 0

Top