text or american date format

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

Guest

I have an import from a finance package that has put a data column into the
american date format or maybe a general text format. How do i convert to
dd/mm/yyyy
 
Just change the display format:

=TODAY() formatted as General shows 38800
formatted as m/d/yyy shows 3/24/2006
formatted as dd/mm/yyy shows24/03/2006

The underlying value is the same
 
Format as your regional dates then do data>text to column, click next twice,
under column data format select MDY and click finish
 
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

How to enter a date in DD-MM-YYYY format 2
Getting MM-DD HH:MM out of Julian date 4
Date Format 1
Date Format 3
Date format 1
date format convert 2
Dates American English? 2
convert non-date format to date format 1

Back
Top