Changing numbers into dates

[allunderme]

Hello,

I have recently been given a large spreadsheet from which i need to calculate the number of days between two columns. The problem is they are not displayed in uk date form. The format for the date fields is 20130501 representing the 1st of May 2013.

Does anyone know how to produce the date from this 20130501 number? I have around 2000 lines of data so going in and manually changing is not really an option.

Any help really appreciated.

Regards

Allun

 

[Jonmo1]

Try

Data - Text To Columns
Delimianted - Next
Uncheck ALL options - Next
Select DATE - YMD
Finish

 

[njimack]

Credit to Rick Rothstein for this...

=--TEXT(A1,"00\/00\/00")

 

[allunderme]

Thank you both

Njimack - i think ill go with your suggestion. It works a dream.

 

[pgc01]

Hi

Same, using another separator:

=--TEXT(E1,"0-00-00")