Posted to microsoft.public.excel.programming

gcotterl[_2_] gcotterl[_2_] is offline

external usenet poster

Posts: 83

Reformat dates

Dates are displayed as follows:

31-Aug
9-Sep
15-Sep
31-Oct
1-Nov

How can I get the dates to be displayed as follows:

Aug 31
Sep 9
Sep 15
Oct 31
Nov 1

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
reformat dates to yyyy/mm/dd	Katerinia	Excel Discussion (Misc queries)	5	March 31st 10 06:49 PM
Reformat dates	David Biddulph[_2_]	Excel Discussion (Misc queries)	0	November 4th 09 06:31 PM
Reformat Data	Jcraig713	Excel Programming	2	September 4th 09 03:58 PM
Reformat Row to Column	Fellow Wanderer	Excel Discussion (Misc queries)	1	May 13th 09 09:54 PM
Cell Reformat	joe925c	New Users to Excel	2	February 9th 09 08:45 PM

All times are GMT +1. The time now is 09:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us