| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid excel automatically detect the cells formatl???
Hi, I have a problem, the day date is in cell c3; and in all the other cells
the format is the general format, if my user makes a mistake and put the date in some other cell that isnt c3 the format of that cell is changed to date format, and all the numbers are wrong because so, There is somehow I can tell excel not to detect automatically the format of the cells so if the user put 23/09/05 and then he erase this data and put 345 the cell didnt show 10/12/1900????? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to automatically make excel detect directory path for linked f | Excel Discussion (Misc queries) | |||
| How do I make a formula automatically detect changes in values | Excel Worksheet Functions | |||
| Excel truncated my cells when copying, how to avoid?? | Excel Discussion (Misc queries) | |||
| Pie Charts Resize Automatically - How To Avoid? | Charts and Charting in Excel | |||
| How Do I Automatically Detect Cell Changes In Excel | Excel Programming | |||
Threaded Mode
