Posted to microsoft.public.excel.worksheet.functions

lcardwell

Posts: n/a

how to change a date format

I would like to sort dates in a spreadsheet by month and day - not year. How
can I change the format to avoid the year being used while sorting?

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
Date Format Problems??	nastech	Excel Discussion (Misc queries)	5	November 14th 05 01:53 AM
MS Query Date Format	scos00	Excel Discussion (Misc queries)	0	October 21st 05 04:58 PM
I cannot change the date format to English canada	DStanfield	Excel Discussion (Misc queries)	2	September 28th 05 06:23 PM
How change Excel default date format to something useful	mjk	Excel Discussion (Misc queries)	1	September 26th 05 08:15 PM
change date function format in footer	Tori	Excel Worksheet Functions	1	January 25th 05 08:18 PM

All times are GMT +1. The time now is 05:51 PM.

About Us

"It's about Microsoft Excel"