[Amy Comer]

I'm having trouble with Microsoft word and excels Find and Replace
functions. Any help would be really appreciated.
Basically i have an excel file that is thousands of columns down..
which I need to change the formatting!!

I am trying to take digits that start out looking like:

0314-T210557

And turn them into:

14-Mar-09 21:05:57


So far, (In Microsoft word) I have used Find and Replace to get rid of
the dash and the T. I have also used find and replace and put a tab in
between the 0314 and the 210557.. (so that when I put it back into
excel, they are in separate columns).

However, I cannot figure out how to get the 210557 looking like a
time.
What I want to do is use Find and replace to put : in between the
21:05:57...
In the find box, I can use ^# .. but it will not let me put those in
the replace box. How can I do this???
So
Find: ^#^#^#^#^#^#
Replace: ^#^#:^#^#:^#^#
But this keeps giving me an error message that I cant put ^# into the
replace box. Any ideas?




Also, Does anyone have any advice how how I can turn 0314.. into 14-
mar-09?

Thank you so much for any help you can give!!!