Date Format Not Responding to MM/DD/YY

S

ssignore

Hello, MS Online Community.
I have a column of dates in a spreadsheet where the date is in the following
format:
"M/D/YYYY"
If I look at Format-Cell, I see the Date category highlighted with the
MM/DD/YY format type selected, however, the dates in the column will not
respond to this format.
I did notice that if I double-clicked inside the cell (for the Edit mode)
and then clicked elsewhere on the spreadsheet, it would convert to the
MM/DD/YY format.
There must be a way in which to switch to the Edit mode for an entire column
instead of double-clicking individually.
Any ideas?
Thanks!
ssignore
 
S

Sheeloo

I thought you would figure that out... :)

ssignore said:
That worked! (As long as 'Fixed Width' is selected instead of 'Delimited')
Much appreciated.
Regards,
Simone
Click to expand...
 
S

Sri

I thought you would figure that out... :)
Click to expand...


Check the articles below to get more insight about date and time
http://funwithexcel.blogspot.com/2009/04/sorting-of-dates-with-different-formats.html
http://funwithexcel.blogspot.com/2009/04/playing-with-time-in-excel.html
http://funwithexcel.blogspot.com/2009/04/get-timestamp-in-excel.html
http://funwithexcel.blogspot.com/2009/04/get-todays-date-without-formulas-in.html
http://funwithexcel.blogspot.com/2009/04/get-todays-date-in-excel.html
 

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

change DD/MM/YY to MM/DD/YY 6
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Change from mm/dd/yy to yy/mm> 3
Convert date to text without changing format dd/mm/yy 3
dd/mm/yy if i change to some other format 2
visual basic user form date format dd/mm/yy not mm/dd/yy 1
How I convert date formatt of dd/mm/yy to mm/yy (not cell format) 1
Microsoft Excel 2003 date format in dd/mm/yy 0

Top