Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pete the Mag
 
Posts: n/a
Default

Thanks Gord. This will be useful. Pete

"Gord Dibben" wrote:

Pete

Download John Walkenbach's Extended Dates add-in.

You can work with dates prior to 1900.

http://www.j-walk.com/ss/excel/usertips/tip028.htm


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 11:49:05 -0800, Pete the Mag
wrote:

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

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"