Convert dates to 8 digit text

  • Thread starter Thread starter Guest
  • Start date Start date
if you really need it as text
=text(A1,"ddmmyyyyy")
assuming it is days before months if not
=text(A1,"mmddyyyyy")
 
To actually "convert" to text you will need to Copy the suggested
formatted cell(s) and do a Paste-Special, Values. Then replace the old with
the new.
 
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

Converting date format 4
Date format 5
Access Running Balance in Access 1
Convert Date string to date format 7
Windows 7 I need to convert date to text 3
Converting Date 03/01/2010 into a simple Month 8
Converting dates to different formats 4
Converting dd:hh:mm to [h]:mm not working. 3

Back
Top