combine cells

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

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
 
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
 
Back
Top