Fields Are Not formatting
I have an Excel database that I am using as my source data.
I have columns in this worksheet representing dates and times, and are
formatted accordingly.
However, when these values are used in my merge document, they do not
take on the proper formatting despite my forced document formatting
code.
ie {MERGEFIELD "Date" \@ "dd-MMM-yy" } is showing the result as a
serial number 39959 instead of 26-May-09
{MERGEFIELD ""F13" \@ ”h:mm AM/PM"} is showing 0.64583333333 rather
than 3:30 PM
Can anyone help me with getting the proper formatting of my fields?
Jenn
--
MaxArk
|