Previous Topic Next Topic

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
Related:

1 response

Answer 1 / 1
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.

:)
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
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.

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses