Just make sure there are real dates in there, not text.

Take a new blank worksheet and enter a date in any cell. Then touch CNTRL-~
several times. You will see real dates toggle back and forth between date
format and number format.

Try this on your problem sheet.
--
Gary''s Student - gsnu200729


"Kevryl" wrote:

I've imported an Excel 200 file into Excel 2003. The date column worked
perfectly as dd/mm on my machine in Excel 2000 but refuses to show that way
in 2003 on another machine. Both are XP, the original "Home edition", the
destination machine on "Professional".

I've gone through Format/cells/number/date/ routine, and
format/cells/number/custom.

I've gone to control panel and Regional Settings . None of these options are
making any difference. Even blank cells in the column will not accept the
date in the typed in format of dd/mm whereas it was never a problem in the
originating machine under Excel 2000.

Any ideas?

Thanks in advance.