This formula will. In cell A1 you have 20050105. In cell B1 put
=CONCATENATE(LEFT(A1,4),"-",MID(A1,5,2),"-",RIGHT(A1,2))
This will result in 2005-01-05

Mike F

"****al shah" wrote in message
...
Hi to all & Sharad Naik
Sharad You have given reply but i am not able to figar-out.

I have open exported file of notepad (TXT Format) Where i have data like
date, item,amtin,amtout,bal.
where data format is DD-MM-YYYY (05-01-2005)
the problem is when i conver this data from text to column, date comes in
number format like 20050105.

is there any way i can put seprater(-) after 4 character and than after 2
charcter (like 2005-01-05 )
any help

Thanks

****al shah