Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Folks ,
I am sure that I must have done something screwy and changed some options around but I have not been able to figure out what the problem is. The issue is that whenever I type a value into a cell it automatically divides that number by 100 and that is the value that is then displayed in the cell (ie typing 3 into the cell results in 0.03 being displayed). This just happened all of a sudden and it does not matter if I am in a file I previously created or a new file and it does not matter what column or row I type the value in. It is worth noting that if I open up previously created files their values are all "intact". I have tried changing the format to pretty much everything, I have even set it to "Number" and set decimal places to 0, and hit OK and it still will show the value as 1% of whatever I typed in. Sorry if this is a stupid mistake but I just cannot figure out the way around it. Thanks in advance. Cheers, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
toolbar line see what you have typed | Excel Discussion (Misc queries) | |||
If typed 12805 then 12/8/05 | Excel Worksheet Functions | |||
can I turn off the memory carry-over from previously typed cells | Excel Worksheet Functions | |||
Excel: Instead of the figure I typed I get ########. Why? | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) |