Default Date Format - ExcelBanter

shep

Posts: n/a

Default Date Format

Using Office 2003 Pro
Is there a way to set default date format to medium; i.e, 12-Nov-05?
I have Win Regional set to dd-mmm-yy, but Excel defaults to short date such
as 12-11-05.

Thanks

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
date format in excel not in line with control panel regional setti	GrahamR	Excel Discussion (Misc queries)	3	August 2nd 05 06:48 PM
Date Format - Conversion	tinkertoy	Excel Discussion (Misc queries)	1	July 14th 05 06:24 PM
How do I keep the date from changing format in a mail merge?	Brynn Wilson	Excel Discussion (Misc queries)	1	June 9th 05 06:44 PM
Australian date format in Excel 2000	Brian Jones	Excel Discussion (Misc queries)	2	March 30th 05 06:13 AM

All times are GMT +1. The time now is 01:48 AM.

Menu

About Us