Excel date defaults to 1900 instead of 2000

G

Guest

Excel is formatting Macro inputted dates back to the 1900's if the user only
enters 04.
ie:- 04 equals 1904

I want it to equal 2004

Thankyou
 
G

Gord Dibben

Peter

What are the Windows Regional Options set to?

Open Control Panel and Regional and Language Options>Regional
Options>Customize>Date.

Set the limits under Calendar if necessary.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

permanent conversion of 1904 date format to 1900 date format 3
convert Excel sheet in 1904 format to 1900 without changing dates 1
Error in Excel date calculations 3
Calculating age when person born before 1900 1
In any format, all my dates in 2000 change to 1900. How do I fix 1
date corruption? 00/01/1900 1
Help with XDATE function add-in 3
Date 1904 - How to convert to Date 1900? 1

Top