I am trying to do a merge where I import several fields, some of which are
dollar amounts. I've done this successfully several times in the last few
years, but now all I get are plain numbers instead of dollar amounts. I don't
want to put $ in every field, because if the field is blank I want it to be
blank. I am copying data out of Access into Excel, then using the Excel
spreadsheet for my data file. In Excel the formatting of the dollar fields
shows a custom field of $#,##0.00;($#,##0.00). This is exactly the same as
when I did this two years ago. The only difference between then and now is my
version of Office. Then was 2002, now I have 2003. Is my new version of
Office trying to "help" me, but actually making it more difficult on me?