What is the cell value, and what is the format type? Is it a number like
20050728 with a custom format, or is it text 20/05/0728? You have a couple
options depending on what the cell values are.

"jtmousel" wrote:

I have imported a text report into Excel. For some reason the date
string on the text file reads as 20/05/0728. Is there a quick way to
reformat the string so it reads 7/28/2005 or even 2005/07/28, for that
matter. I really don't want to manually edit 300+ lines! Thanks.