locked
Decimal automatically added in Excel (XP-2003-2007) RRS feed

  • Question

  • If you enter the number 39917.05669 or 14908.88136 in a cell in excel 2002 or 2003 or 2007 it change the information for 39917.0566899999 and 14908.8813599999 automatically, and it's same if you change the format .
    So it changes data when you use it in a formula. 
    The only way that I found to be sure of the number that I have to use is to enter 39917 + 0.05669 or 14908 + 0.88136 in those cells.

    ANY IDEA ?
    Wednesday, October 7, 2009 2:12 PM