My Cell Input is Changed to Different Value by Excel

[Jeff of Napa]

Hi! I typed in this value in a cell: 525.5, and hit the enter key.

Excel changed the value to a date and time: 6/18/1901 12:00 PM.

What the heck is going on?

Thanks. Jeff, Napa, CA

 

[akphidelt]

The cell is formatted as a date. Go to Format-->Cells and then change the
format to a number!

 

[Jeff of Napa]

Thanks a ton! That worked!

The cell is formatted as a date. Go to Format-->Cells and then change the
format to a number!

 

[Jeff of Napa]

The cell is formatted as a date. Go to Format-->Cells and then change the
format to a number!