excel has an issue with dates prior to 1900

G

Guest

I am typing in dates in excel.

I type in 3/30/1978 and it comes out 30-Mar-1978

Than I type in 3/30/1878 and it comes out 3/30/1878 but it should appear
30-Mar-1878

I have Excel 2000.
Can a fix be made????
Thanks
Shaz
 
N

Nick Hodge

Shaz

Two things are at play here

1) Excel cannot recognise dates prior to 1st January 1900 as dates so typing
in the 1878 date is just being seen as text and you get what you type

2) The other (1978) is to do with your language settings in Windows, Go to
start>control panel>regional setting (Maybe international settings) and
change the location to your current one. I suspect US. (Looks like you have
it set at Europe or UK). Restart Excel.voila!

No fix needed!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

Import Excel dates as text 5
How do I count the number of events in a 90 day period? 2
Excel Formatting with dates 3
Help with formating 2
Excel Formula - Count Dates from another Sheet 8
Dates prior to 1900 are text 3
Calculating occupational sick pay entitlement 0
How to count in month? 4

Top