Can anyone tell me how to format a cell so that when a
date is entered it formats as a date and when a number is
entered it formats as a number.

If you use general it auto formats for a date but if you
enter a number in the same cell after a date has been
entered then it still thinks it's a date.

Any help will be appreciated.