date format

P

pothios

Hi all,

I have a problem with date formatting.

i have the following dates in MM/DD/YYYY format:
4/1/2010
4/2/2010
04/15/2010

when i tried to re-format the date, the 1st 2 column is formatted
sucessfully but the last date will always remain unchange no matter what
format is selected. Can anyone please explain the reason for this issue?
 
D

David Biddulph

Yes.
As you will have now realised, if your Windows Regional Settings in Control
Panel (not Excel) are expecting DMY, not MDY, then 04/15/2010 will be
treated as text, not a date.
 

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

Top