I'm having a problem here... I export a report form my company software into .csv format, which i then convert to regular Excel format, and use the list for a mail merge. My problem is that when it is exported into .csv, it removes the trailing Zeros for any dollar amount fields, it also removes any leading zeros in the zip code fields (My local zip codes all begin with a zero). To fix the dollar amount fields, I just change the data type to Currnecy. That works fine, but when the list is exported to Word for the mail merge, it just removes those trailing zero's again. The only way it works is if I change the data type to text, then go through every row and add the zero's where needed. What can I do to avoid having to manually enter the zero's and have them exported to Word while keeping the decimal to 2 places? The leading zero's in the zip code fiels aren't THAT important if nothing can be figured out. Since most of them are the same anyway, I just change the first one, then fill the rest of them.