"Steved" wrote in message
...

Hello Alan from Steved

taking your example 11205

Yes it is a date but for my purpose I want to turn it into 11/2/05
using custom _-$* #,##0_-;-$* #,##0_-;_-$* "-"_-;_-@_-
this turn into $11,205 now if I can use something like this
to turn 11205 into 11/2/05 i would be happy or is it not possible.

Thankyou.


Hi Steved,

How would you enter 1 Dec 2005?

Alan.