"David Smithz" wrote in message

Also related to my previous posting is now that I want to change lots of
values in a cell from one format to another. In that currently they have
dates in them that Excel does not recognise as dates:
e.g.
"May 7 2004 7:54AM"


Firstly I set all the cells types et to be a customer which has time and
date displayed (i.e. dd/mm/yyyy hh:mm).

Now if I rearrange the date to have the day first and put a space between
the time and the AM then Excel recognises the entry as a date and time.
Now I want to apply that to every cell in the spreadsheet without having to
do it manually each time. How would I write a macro for that because when I
tried I got strange results.

Thanks

Dave