Re-Format Date

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

Guest

Hi
Can someone please help in how I can re-format the date from ddmmyy back to
dd/mm/yy

or

If someone knows how to check whether a date entered as text is before or
after current date.

ie "110606" < date

when I try it never works as it sees the 110606 as a text field and not a
date field. If I change todays date to a text field then as far is it is
concerned todays date is greater but if it would have been earlier this week
then it would see the 110606 as greater.

Any help would be great.

Thanks
Noemi
 
Try data>text to columns>next>next>column data format>date>DMY

This will change it to a real date.


Gord Dibben MS Excel MVP
 

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

Excel is changing date format incorrectly 7
Finding Date in an overseas format 20
Incorrect Date Returned 1
Need advice re: date without slashes 6
Userform and Text Box Date 2
Problem with date formatting 5
Mysterious re date Format 1
VBA Go to Today's Date 4

Back
Top