Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically divides number by 100
Hi,
I am having a problem with Excel. Whenever I enter a number in a cell, excel divides it by 100 and then stores it. So when I enter 12 for example, then the number is stored as 0.12. A 100 is stored as 1. So seems like there is some setting which is causing this. However, I am not able to figure out what. Also, when I enter "=sum(100, 12)" in a cell, the number is stored correctly as 112. Also, if the value is stored as text and then converted to a number, the number is shown correctly. I am using Excel 2003 SP2, on Windows XP Professional, and have the Solver addin installed. This has started happening in the last couple of weeks. Please help! Thanks, Ravi Budhia |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically divides number by 100
Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check
from the FIXED DECIMALS PLACES checkbox to solve the problem. -- Kevin Backmann "Ravi Budhia" wrote: Hi, I am having a problem with Excel. Whenever I enter a number in a cell, excel divides it by 100 and then stores it. So when I enter 12 for example, then the number is stored as 0.12. A 100 is stored as 1. So seems like there is some setting which is causing this. However, I am not able to figure out what. Also, when I enter "=sum(100, 12)" in a cell, the number is stored correctly as 112. Also, if the value is stored as text and then converted to a number, the number is shown correctly. I am using Excel 2003 SP2, on Windows XP Professional, and have the Solver addin installed. This has started happening in the last couple of weeks. Please help! Thanks, Ravi Budhia |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically divides number by 100
Tools/ Options/ Edit
Uncheck: Fixed decimal places -- David Biddulph "Ravi Budhia" <Ravi wrote in message ... Hi, I am having a problem with Excel. Whenever I enter a number in a cell, excel divides it by 100 and then stores it. So when I enter 12 for example, then the number is stored as 0.12. A 100 is stored as 1. So seems like there is some setting which is causing this. However, I am not able to figure out what. Also, when I enter "=sum(100, 12)" in a cell, the number is stored correctly as 112. Also, if the value is stored as text and then converted to a number, the number is shown correctly. I am using Excel 2003 SP2, on Windows XP Professional, and have the Solver addin installed. This has started happening in the last couple of weeks. Please help! Thanks, Ravi Budhia |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically divides number by 100
Thanks Kevin! That fixed the problem!
Ravi "Kevin B" wrote: Click TOOLS, select OPTIONS and then click the EDIT tab. Remove the check from the FIXED DECIMALS PLACES checkbox to solve the problem. -- Kevin Backmann "Ravi Budhia" wrote: Hi, I am having a problem with Excel. Whenever I enter a number in a cell, excel divides it by 100 and then stores it. So when I enter 12 for example, then the number is stored as 0.12. A 100 is stored as 1. So seems like there is some setting which is causing this. However, I am not able to figure out what. Also, when I enter "=sum(100, 12)" in a cell, the number is stored correctly as 112. Also, if the value is stored as text and then converted to a number, the number is shown correctly. I am using Excel 2003 SP2, on Windows XP Professional, and have the Solver addin installed. This has started happening in the last couple of weeks. Please help! Thanks, Ravi Budhia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell divides by 10 | Excel Discussion (Misc queries) | |||
Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) | |||
Problem: Excel divides all my entries | Excel Discussion (Misc queries) | |||
Excel divides number by 10e6 unless followed by decimal point. | Excel Discussion (Misc queries) |