Excel 1900 Date Problem

B

bluesband

I'm modifying an existing spreadsheet. When I modify an input cell t
change the date, the date in the cell appears incorrect. Example:
enter 1/14/2001 and the cell reads 1/0/1900. However, in the task ba
the correct date appears.

Any clues as to why this happens
 
N

Norman Harker

Hi bluesband!

Sounds to me that youe are pressing "=" before you put in the date.

This "tells" Excel 1 divided by 14 divided by 2001 which Excel returns
as 0.0000356964374955379

You then format as a date to get 1/0/1900.

Don't press the "=" just enter:

1/14/2001
Format as date
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

Ron Rosenfeld

I'm modifying an existing spreadsheet. When I modify an input cell to
change the date, the date in the cell appears incorrect. Example: I
enter 1/14/2001 and the cell reads 1/0/1900. However, in the task bar
the correct date appears.

Any clues as to why this happens?
Click to expand...


In the formula bar, do you really see 1/15/2001? Or is what you are seeing
=1/15/2001.

If the latter, check Tools/Options/Transition and ensure that Sheet
Options/Transition Formula Entry is DEselected.


--ron
 
B

bluesband

The problem was that on the Tools/Options/Transition tab the Shee
Options were checked thereby automatically changing the date into
formula by inserting a = sign before the date.

When Sheet Options are unchecked dates can be entered and no
automatically converted to a formula
 
Top