Rosa Campos

Posts: n/a

the date format is not working ,sort by date doesn't work.

I have this Excel spreadsheet, I took the year from one column, and the month
from another column and put it in one column together, it looks like AUG
1989, but when i try to sort by Date it doesn't. I'm sure the format is
incorrect.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I keep the date from changing format in a mail merge?	Brynn Wilson	Excel Discussion (Misc queries)	2	February 1st 07 05:19 PM
Why Does Date Format Change on Chart	John Taylor	Excel Discussion (Misc queries)	0	September 11th 05 08:16 AM
Date Format when incoming date can be 0	DP NY10601	Excel Discussion (Misc queries)	3	June 3rd 05 11:23 PM
Date format	Jean-Francois Boucher	Excel Discussion (Misc queries)	2	February 22nd 05 04:35 PM
Problem with Date format from VBA code	twig	Excel Discussion (Misc queries)	3	December 7th 04 06:01 PM

All times are GMT +1. The time now is 02:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us