How do I convert date values to non-date format e.g. 01-06-78?

Hello,

we have a large spreadsheet (Excel 2003) with bank codes that have been
automatically converted to date format. Any bank code in column G that could
also be a date, such as 03-07-78, will get converted to 03/07/78. Is there a
way to convert these 'dates' back to format for bank code (we do need date
format for other column)?

Thank you,

I think you'd be much better off reimporting the data into excel.

If you're importing a text file, make sure that the extension is .txt. Then
file|open your workbook and specify Text for that field.

But you could try a helper column with formulas like:

=IF(ISNUMBER(A1),TEXT(A1,"mm-dd-yy"),A1)

(But I'd start from scratch and re-import.)

mikelenno wrote:
>
> Hello,
>
> we have a large spreadsheet (Excel 2003) with bank codes that have been
> automatically converted to date format. Any bank code in column G that could
> also be a date, such as 03-07-78, will get converted to 03/07/78. Is there a
> way to convert these 'dates' back to format for bank code (we do need date
> format for other column)?
>
> Thank you,

--

Dave Peterson

Thanks Dave. I'll check when back at work next week.

"Dave Peterson" wrote:

> I think you'd be much better off reimporting the data into excel.
>
> If you're importing a text file, make sure that the extension is .txt. Then
> file|open your workbook and specify Text for that field.
>
> But you could try a helper column with formulas like:
>
> =IF(ISNUMBER(A1),TEXT(A1,"mm-dd-yy"),A1)
>
> (But I'd start from scratch and re-import.)
>
> mikelenno wrote:
> >
> > Hello,
> >
> > we have a large spreadsheet (Excel 2003) with bank codes that have been
> > automatically converted to date format. Any bank code in column G that could
> > also be a date, such as 03-07-78, will get converted to 03/07/78. Is there a
> > way to convert these 'dates' back to format for bank code (we do need date
> > format for other column)?
> >
> > Thank you,
>
> --
>
> Dave Peterson
>