Pete the Mag

Posts: n/a

Formatting dates prior to 1900

I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834.
Can this be done?

Thanks
--
Pete

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
graph dates revert to 1900	Richard Goh	Charts and Charting in Excel	10	February 16th 05 02:39 PM
conditional formatting overdue dates	Joooooooo	Excel Discussion (Misc queries)	1	February 8th 05 11:33 AM
Formatting dates in the future	Compass Rose	Excel Worksheet Functions	3	January 17th 05 10:39 PM
Need to sort dates before 1900 in proper order	sandage_2000	Excel Discussion (Misc queries)	3	January 8th 05 03:31 AM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM

All times are GMT +1. The time now is 11:57 PM.

About Us

"It's about Microsoft Excel"