Posted to microsoft.public.excel.misc

Posts: n/a

Dates

Hi

Trying to format dates such as 17/03/2006 as 17 March 2006. However,
even when I change the 'Type' to English UK ther above date won't
change and 02/06/2006 returns 06 Feb 2006. Is there a setting that
needs to be changed?

Thanks

Mick

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
formula to add dates.	S S	Excel Worksheet Functions	8	April 5th 06 07:53 PM
Pre-1900 dates	Richard Gadsden	Excel Discussion (Misc queries)	1	March 26th 06 12:46 AM
need to convert list of dates to count no. of dates by week	neowok	Excel Worksheet Functions	13	January 30th 06 03:54 PM
PivotTables - Group Dates, excluding dates	Todd1	Excel Discussion (Misc queries)	4	December 10th 05 05:06 PM
Calculating number of days between two dates that fall between two other dates	[email protected]	Excel Discussion (Misc queries)	5	October 26th 05 06:18 PM

All times are GMT +1. The time now is 05:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us