The simplest method may be to search for 31032006 and replace with
01042006: on the menu click Edit Replace and fill in the boxes as
appropriate.

I started doing that, but with one column per day and 200 rows, it takes
quite a while to do.

I tried repeating the steps in a macro to save effort, but it still
took a long time.

I have several spreadsheets like this to do and dont want to spend so
long doing each one.


--
ingleg
------------------------------------------------------------------------
ingleg's Profile: http://www.excelforum.com/member.php...o&userid=33037
View this thread: http://www.excelforum.com/showthread...hreadid=528538