Date Conversion pre. 1900

's Computer Specifications

Hi,
Could someone help me with the following problem.

I need to convert dates from:

01/02/1800 to 1 Feb 1800

I know excel's default year is 1900.

Any help would be appreciated.

Regards

SeeAll

's Computer Specifications

John Walkenbach has an add-in where you can use pre 1900 dates

http://j-walk.com/ss/excel/files/xdate.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"SeeAll" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> Could someone help me with the following problem.
>
> I need to convert dates from:
>
>
> 01/02/1800 to 1 Feb 1800
>
>
> I know excel's default year is 1900.
>
> Any help would be appreciated.
>
> Regards
>
>
> SeeAll
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
permanent conversion of 1904 date format to 1900 date format	Jos	Microsoft Excel Worksheet Functions	3	21st Jul 2009 06:32 PM
Odd date issue where date is between 1 January 1900 and 1 March 19	=?Utf-8?B?R1BP?=	Microsoft Access Queries	2	15th Mar 2007 02:18 AM
HAVE A COLUMN OF DATE PAYMENTS ARE DUE DATE CHANGES TO 01/00/1900	=?Utf-8?B?Q0s=?=	Microsoft Excel Misc	3	7th Jul 2005 07:06 PM
Excel date formatted cell displays date entered as Jan-01-1900	=?Utf-8?B?RGVybW90?=	Microsoft Excel Crashes	0	29th Sep 2004 11:35 AM
Date 1904 - How to convert to Date 1900?	Alex St-Pierre	Microsoft Excel Setup	1	4th May 2004 01:25 AM