| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to open eer file without converting 8-7440 to a date?
Trying to pull a report from one program that has file in eer format. Need
to open in excel but Excel auto converts a number (8-7440) into a date in August. Have tried many different ways to open the report but it converts to a date everytime. When I format the cells to be 'general' or 'number' it does not convert the number back correctly (lists 2023658 instead of 8-7440). Any suggestions? Help...please help....this is driving me to drink. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open file if cell date is less than today+30 day? | Excel Worksheet Functions | |||
| Date open file with date saved | Excel Worksheet Functions | |||
| Incorrect date value when open DBF file in Excel | Excel Discussion (Misc queries) | |||
| todays's function, if I open file date changes | Excel Discussion (Misc queries) | |||
| Excel File Open Box - want Date Modified | Excel Discussion (Misc queries) | |||
Threaded Mode
