CHANGE TEXT TO DATE FORMAT
 

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

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

"deniseh" wrote:

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

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

Stefi

€žbj€� ezt Ã*rta:

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

"deniseh" wrote:

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