date in text format

M

Martha

I'm trying to do a mail merge in Publisher than has a date field. It converts
it to text - and becomes a 5 digit number.Publisher is very limited in terms
of mail merge power (unlike Word - but I can't use Word due to Text boxes and
needing to get several on a page) . I then decided I'd convert the date field
in excel into Text, so then Publisher would then read it in the correct
format. However, I can't get away from the 5 digit number. I've read
everything I can find about date and text. I"ve tried copy and "paste as
values", etc - and I get the 5 digit number. Any suggestions?
 
F

Frank Kabel

Hi
try the following formula in a helper column
=TEXT(A1,"MM/DD/YYYY")
and copy down for all rows
 
Top