| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
prevent 4/5 in a cell automatically transfer to a date format
I have a .csv file with some number like 4/5 (x/y), but when open in Excel,
it automatically transfer to a date, how to prevent this and preserve the original format (x/y)? (In fact, even I type 4/5 in a cell, it will automatically change to a Date, how to prevent it?) I'm using Excel 2002 version Thx!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
| How can I format a cell so date field only displays the Month? | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
