Changing date format in excel [Closed]

Report
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
-
 Blocked Profile -
I have imported dates in an excel spreadsheet from WinQs.sql and opened the file in excel.
the date format is 07/11/2009 but I want to change the date to filter it. Filtering as it is, filters according days first then months. I would like to filter it in exact dates. 2009/11/07, does just that.
My preblem is either with the filtering or changing the date.

Thanks

1 reply


Hang in there, see if this helps, use the TEXT function:
=text(value,format)

So, you could do something like:
=TEXT(B4,"yyyy/MM/DD") ; or,
=TEXT(B4,"yyyy/DD/MM")

I hope I have understood correctly.

:)
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014

ac3mark

Thanks! It works, but I still have a problem reading the date imported from WinQs.sql. If I type over the previous date, imported, even just a abbreviated date it works. It seems that it does not pick up the value in my previous date column. Your response is appreciated and helps a lot!

QSVV
Blocked Profile
Try this. Make certain the column is formatted as text and not date.

Let me know.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!