combine cells

[RobcPettit]

Can anybody advise, Im sure theres a simple solution. In E1 I have entered a
date, 7/1/1994 In cell A1 Ive entered a formula ="I:\My Documents\Metastock
Converts\" & E1. This give a result of I:\My Documents\Metastock Converts\34341
were 34341 is the date. I would like this as the actual date 7/1/1994. eg I:\My
Documents\Metastock Converts\7/1/1994. Is there a way of doing this.
Regards Robert

 

[TroyW]

Without leading zeroes:
Cell A1: ="I:\My Documents\Metastock Converts\"&Text(E1,"m/d/yyyy")

If you need the leading zeroes on the month and day then:
Cell A1: ="I:\My Documents\Metastock Converts\"&Text(E1,"mm/dd/yyyy")

Troy