| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Problem
thanks
regards FSt1 "Sheeloo" wrote: Excel 2007 office buttonexcel optionsadvanced clear the check box 'Automatically insert a decimal point' "FSt1" wrote: hi you have fixed decimais in place. 2003-on the menu bar..... tooloptionsedit tab uncheck fixed decimal places 2007 office buttonexcel optionsnot sure after this. 2007 expert - help Regards FSt1 "rqueneau" wrote: Very strange behavior just started. Even on a new spreadsheet, if I enter a number in a cell, like the number 5, it's instantly diveied by 100 and the cell contains 0.05. I work with a lot of engineering spreadsheets and they all started doing this. I've tried formatting the cells to General, Number (with no decimal places) and others, but it continues to happen. Ran Office diagnostics but it came up with nothing. The problem is local to my laptop only. I emailed a problem spreadsheet to my home system and tried it there. Everything works fine. I enter 2, and the cell shows 2. Has anyone seen this before and if so, what is the fix? Please help as this is making my life miserable. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data entry problem | Excel Discussion (Misc queries) | |||
| data entry problem | Excel Worksheet Functions | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
