View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob[_4_] Rob[_4_] is offline
external usenet poster
 
Posts: 37
Default 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