| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help: Excel automatically change input values
Excel version: 2003
Symtpoms: Whenever I input 1, excel automatically change it to 00.1. Whenever I paste a value with a comma (",") as a deliminator, excel automatically split it into two cells and remove the comma. Possible cause: The whole problem starts when I tried to split values in a column with comma deliminators. It seems that Excel remembers this action. I have not found a way to remove this hidden action. What I have tried: I have tried Tools-Options-Calculation, set Calculation on "Manual". It has not solved the problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input 7 in a cell in EXCEL 2000, it will automatically change to 8 | Excel Discussion (Misc queries) | |||
| Why does Excel change the dates I input? | Excel Worksheet Functions | |||
| All values automatically change to zero | Excel Discussion (Misc queries) | |||
| How di get excel to automatically change cell values | Excel Discussion (Misc queries) | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Threaded Mode
