date in text format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
try the following formula in a helper column
=TEXT(A1,"MM/DD/YYYY")
and copy down for all rows
 
Thank you - it worked! Now on to the next stumbling
block.... Thanks Martha
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Date format to Text Date for use in Mail Merge 3
Text dates to date format 6
Date converted to Text Number 6
format a date to text 7
This cell contains a date string rep. with only 2 digits for the y 5
Convert date to text without changing format dd/mm/yy 3
Data being corrupted by excels automatic date recognition re-forma 6

Back
Top