CHANGE TEXT TO DATE FORMAT

D

deniseh

Hi, I wonder if you would help me? I have to import a file from our accounts
package in .csv format into Excel on a daily basis. This works well apart
from the date which appears as, say, 20050901. I should like it to be
01/09/2005 or similar. I have tried formatting the column into date but
nothing seems to work correctly for me. Is there an easy way of converting a
column to the correct format please?
Thanks for your time.
Denise
 
B

bj

if this is the common format
use
=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(RIGHT(A1,2)))
 
S

Stefi

VALUE is not necessary, for me
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
also worked.

Stefi

„bj†ezt írta:
 
Top