Having trouble with Date format.

[Barry Katcher]

I've formatted a column of cells with the "m/dd/yyyy" date format and, no matter what date I input, the cell returns "1/0/1900". This is in a workbook that I imported from Lotus 1-2-3, if that helps - when I format a new Excel workbook, the date works just fine. Can anyone help?

 

[Barry Katcher]

MARK - THAT'S IT! You got it, mate, thanx a lot. And thanks to all you others for the input. God, now I can sleep tonight.

 

[Barry Katcher]

MARK, THAT'S IT! Thanx a lox, and thanx to all you others for your input. God, now I can sleep tonight.