My Cell Input is Changed to Different Value by Excel
 

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

My Cell Input is Changed to Different Value by Excel
 

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

"Jeff of Napa" wrote:

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

My Cell Input is Changed to Different Value by Excel
 

Thanks a ton! That worked!

"akphidelt" wrote:

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

"Jeff of Napa" wrote:

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

My Cell Input is Changed to Different Value by Excel
 

"akphidelt" wrote:

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

"Jeff of Napa" wrote:

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