Make sure the cells are not formatted as text, then do datatext to columns,
click next twice, in step 3 select date under column data format and from
date dropdown select DMY, click finish

--

Regards,

Peo Sjoblom

"Andrew" wrote in message
...
Hi,

I have a text value for the date. I want to convert it to a number (ie
from 190707 to 39282). Please note the format of the date is ddmmyy
--
Andrew