| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date problem in excel
I have a problem that when I open a file, like text or csv file, the cell
with number dash number, ex. 10-5, will be automatically changed to date format. But this really affect my data analysis. I know we could add ' before typing or change cell format before typing, but how to cancel this autoformat when opening another file?? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
| Date Math Problem | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
