I have a sheet where I am referencing another sheet which is in another
workbook and is independant.

For the sake of the exercise, Column C can either store a number or a date.
The numbers are all over 150,000 (refering to a reference number)

The posistion of the dates changes according to the schedule in the original
workbook.

I want to be able to format the column so that numbers that indicate dates
(say less than 50,000) are formatted as dates, i.e 15/01/09, and number
greater than this are represented as numbers/general.


Thanks.