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?
 

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

Default date format (with shortcut keys) 2
Need difference in Hrs.mm.ss 3
Excel 2007 text import as text not date 3
Excel 2002: How to make the date format uniform ? 1
Format Date Filter Problem 1
Highlight date nearest to TODAY() 1
Subtract 12 hours from date/time 6
Footer date format 2

Top