Conditional Date formatting in a column of numbers

[Alco Engineer]

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.

 

[Barb Reinhardt]

Try putting this in for the custom format

[<=50000]dd/mm/yy;General

 

[Alco Engineer]

Worked a treat.

Thank you!

Try putting this in for the custom format

[<=50000]dd/mm/yy;General
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

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.