StuartTheBrit

Posts: n/a

Date Format

I would like Excel and Access to display dates in the following format:
Wednesday 3rd August 2005

Currently, I can only get a display of :
Wednesday 3 August 2005 using dddd d mmmm yyyy

Grateful for help getting 3rd instead of 3 displayed.

Many thanks

Stuart

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
Compare dates (one cell not in date format)	craigcsb	Excel Discussion (Misc queries)	5	June 28th 05 05:07 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
Date format	Jean-Francois Boucher	Excel Discussion (Misc queries)	2	February 22nd 05 04:35 PM
USING THE DATE FORMAT IN EXCEL	teach	Excel Discussion (Misc queries)	3	December 14th 04 11:55 PM
Date format collapses diagram	Richard H	Excel Discussion (Misc queries)	3	December 14th 04 11:08 PM

All times are GMT +1. The time now is 03:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us