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

Similar Threads

How to add day to PWA 2016 date format? 0
Default date format (with shortcut keys) 2
Need difference in Hrs.mm.ss 3
Format Date Filter Problem 1
Subtract 12 hours from date/time 6
Excel 2007 text import as text not date 3
Excel 2002: How to make the date format uniform ? 1
Date Formats 4

Top