Changing date format in excel

Closed
QSVV
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
- Jan 22, 2014 at 10:54 AM
 Blocked Profile - Jan 23, 2014 at 09:32 AM
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

Blocked Profile
Jan 22, 2014 at 11:06 AM
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.

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

Jan 23, 2014 at 01:48 AM
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
0
Blocked Profile
Jan 23, 2014 at 09:32 AM
Try this. Make certain the column is formatted as text and not date.

Let me know.
0