Format as date and add -- in front of "31/1/2005" however if you have US
regional settings you will always get text since there is no month 23 in
that case you need to change the concatenate formula or the regional
settings

--
Regards,

Peo Sjoblom

(No private emails please)


"M&A_Jack" wrote in message
...
I have a date format written as "31/1/2005", when I concatenate after I've
separated text to columns I can't change format to 31-Jan-2005.