Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I opened a xls file with MS Excel that's been opened and reopened each week
for the last year. Now, I click to open and get a notice - that data is delimited. How do I return things to "normal"? I can see no regular numbers or words, just gobbledy gook. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
An xls file doesn't need the text wizard to open it.
What is the file extension? [Make sure that in Windows you are viewing the extensions on files, and not fooling yourself with something like something.xls.txt which (if you are hiding extensions) might look as if it's called something.xls and actually be an Excel file rather than a text file, burt would be treated as a text file.] Try opening the file in Notepad, and see whether you can read it (in which case it's text) or whether it looks like gobbledygook there. If the latter, take a copy of the file and change the extension from .txt to .xls. Another option if you are struggling is to go back to the backup of your file. -- David Biddulph "CommenTerry" wrote in message ... I opened a xls file with MS Excel that's been opened and reopened each week for the last year. Now, I click to open and get a notice - that data is delimited. How do I return things to "normal"? I can see no regular numbers or words, just gobbledy gook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
space delimited files now tab delimited | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
Noy able to update the PowerPoint charts with the data from ExcelS | Charts and Charting in Excel | |||
how do I import tab delimited data? | Excel Worksheet Functions |