Excel number / date conversion

[markperry]

I've just pulled some data out of an ODBC connection into Access an
then exported it to Excel.

The dates are currently in the format 20031109. But the built in dat
convertor (from Format Cells) doesn't do anything, even if I convert i
to a 'proper' number first.

How can I convert this to 09/11/2003 so that I can do some date - base
arithmetic and work out difference in days

 

[Ron de Bruin]

Hi

Use this formula
=DATE(MID(A1,1,4),MID(A1,7,2),MID(A1,5,2))

 

[Gord Dibben]

Select the column and Data>Text to Columns>Next>Next>Column Data
Format>Date>YMD(YDM?)>Finish.


Gord Dibben Excel MVP

 

[markperry]

Absolute genius - you've saved me a lot of head scratching.

Thanks