Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    format cells (2002 sp2)

    Hi,
    When I enter a number in a worksheet Excel formats it as 0.000000n.
    Even when I format the cell a number with two decimals and I put in a 1, the outcome is 0.00
    When I take the worksheet to Excel 97 on the same PC the numbers are still the same.
    But when I put in a new number or modify the number already put in, the correct format follows.
    Like when I put in a 1 in the example above the outcome will be 1.00
    What's happening? TIA

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: format cells (2002 sp2)

    It sounds like you have a VBA routine in class module for the change event that is changing all input to be 0. Try the things that Jan Karel Pieterse suggests in this Star Post.
    Legare Coleman

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: format cells (2002 sp2)

    Hi,
    If you look under Tools-Options and select the Edit tab, is the Fixed Decimals option checked? If so, uncheck it and the spreadsheet should then work ok.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: format cells (2002 sp2)

    Hey Rory the Pelvis <gr>,
    That's it!!!
    Simple but effictive, thanx.
    Any idea how it was checked, because I can hardly imagine it is checked by default.
    And this user is one that wouldn't dare clicking on anything beyond input in cells.
    Nevertheless: Fixed Decimals have left the building.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •