Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculations (XP office version)

    Big question. this form was made at work and I want to change it in a small way if I can. Is there a way to total up the cells and keep the decimal point in the right place? I can eaily use a formula to add but instead of getting 500 I need it to auto calculate 5.00. Does this make sense? I have included a picture that better explains my question. If you figure it out please send me your completed form with instructions. Thanks! I am post again and I will include the the form for you to play with.Thanks a bunch.
    Attached Images Attached Images

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations (XP office version)

    Could you perhaps elaborate, I fail to understand your exact needs. If one adds numbers in Excel, one doesn't have to worry about the decimal place, it just adds the numbers.

    Is it because the digits of each number are in separate cells?

    If so, why not have the numbers in one cell? it can be formatted to align the decimal separator.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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