So 05:32 = 1 Feb 2005?
If so, then assuming that all dates are after 1 Jan 2000, and all YY
are 2 digits (ie 2005 is always 05 and never just 5), and your date
to convert is in A1, then this should work ...

=DATE(VALUE(LEFT(A1,2))+2000,1,1)+MID(A1,4,3)-1

Rgds,
ScottO

"Sam" wrote in message
...
| Hello,
|
| I have a column with dates in the format YY:DD [here DD stands for
day of
| the year]. Is there a way to have a column that represents the
same dates in
| the normal MM/dd/YYYY format?
| [MM=month#, dd=day# (day of the month), YYYY=year]
|
| Thank you!