[Sara]

Hi there

I'm doing a mailmerge from an excel spreadsheet. It has a variety of time
values, dollar amounts, and rounding.
While I have worked out how to write the code to include the formatting, how
do I extend this so that blanks show as either nothing or N/A?
Time fields currently have this:
{ MERGEFIELD Mon_Start \@HH:mm }
Blank time fields are showing as "00:00" and I need them to be blank
Rounded fields currently have this:
{ MERGEFIELD Hourly_Rate \# "0.000000" }
Blank fields are showing as "0.000000" and I need them to be "N/A"