Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go. I have been using a particular spreadsheet for 3-4 years and was able to enter integers into a column of cells, and having formatted the cells as numbers having no decimal place have them show as integers and behave as integers in formulae. Some weeks ago for reasons entirely unknown to me Excel insists on dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0 if I format the cell as an integer but acts like a 0.01 in formulae. Excel also does this in new spreadsheets. I have noticed some weird things about this problem, in particular that the same spreadsheet run on another computer behaves the way it was originally designed to - i.e, when I enter 1 I get 1. The problem is not present when I run Excel in safe mode or when I run Windows XP in safe mode, but it is very inconvenient to run Excel in safe mode and I shouldn't have to anyway. I have checked for add-ons for Excel but they there don't seem to be any. I don't get the problem when I run the spreadsheet under OpenOffice Calc as an Excel program, but I'd like to be able to run it under Excel. Can anyone help please or point me to a document in the Microsoft labyrinth? -- Regards, Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How many decimal places can a cell display? | Excel Worksheet Functions | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
Excel defaulting to 3 decimal places when using the gen. format | Excel Discussion (Misc queries) | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |