Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FV with inconsistant cash flow | Excel Worksheet Functions | |||
I can't find why my formula is inconsistant - please help | Excel Worksheet Functions | |||
Inconsistant Formula | Excel Discussion (Misc queries) | |||
Inconsistant calculations | Excel Discussion (Misc queries) | |||
Inconsistant Data Cleaning | Excel Discussion (Misc queries) |