| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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, |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
