Put 1 in an empty cell, format the cell as a date, copy the cell
select all text dates, do editpaste special and select multiply


--
Regards,

Peo Sjoblom



"PWS" wrote in message
oups.com...
I wish!

Does any mVP or anyone one from Microsoft have a solution?

Is it possible to change that field (column) to a numeric
field rather than text? That way everything would work normally.