+ Reply to Thread
Results 1 to 3 of 3

set the precision value of cell as displayed value

  1. #1
    Registered User
    Join Date
    06-19-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2007
    Posts
    5

    set the precision value of cell as displayed value

    I entered '=15/7 ' in cell 'A1' and answer was 2.142857143
    Then I decreased the number of decimal places to 2. ( that means 2.14 )
    I entered '5' in cell 'B1'
    Then 'A1' cell multiply by 'B2' cell .
    Answer was 10.71428571
    Then I decreased the number of decimal places to 2. ( that means 10.71)
    but, simply 2.14 * 5 = 10.70
    That means Excel use actual value in the cell (2.142857143) for calculation instead of 2.14
    I like to know how to use the number, that appears in cell (2.14) to calculation ??
    ( without using ROUND function).
    Please help.

    Thank you.
    Last edited by ctbabeyakoon; 06-19-2011 at 08:37 PM. Reason: new topic will be describe the thread more accurately

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: set decimal places

    Try setting 'Set precision as displayed' under options.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    06-19-2011
    Location
    Sri lanka
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: set decimal places

    It worked,..!!!
    Thank you very much Dom.
    It helps my calculations comprehensively.
    Thanks again Dom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1