Text format inconsistant
When I export a spreadsheet to a text file and open it via Excel (ie I right
click the text file and select Open with Excel), one of the cells (of many
like it) where I have a value such as 9-5510 are shown in a date format as
Sep-10 (the formula bar says 1/09/5510). The text file opened in Notepad
shows the same cell as 9-5510 which is as it should be.
Yet the value 1-1111 shows correctly in both the text file and if opened via
Excel.
The spreadsheet that that the export was done from has all these cells
formatted as General.
Rob
|