1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Fixing currency to 2 decimal places

Discussion in 'Business Applications' started by PincivMa, Dec 7, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. PincivMa

    PincivMa Thread Starter

    Joined:
    Mar 13, 2004
    Messages:
    378
    Hi There

    I'm at a loss on how to fix a currency dollar amount to 2 decimal places. I'm not talking about the excel format cells menu to 2 decimal places, since that is very easy to do. Here is my problem. I have a formula that calculates a dollar amount. Say it comes out to $123.45. Now I need to hard code that amount by paste special value. The number now looks something like this $123.458956412589. Is there a way that this amount can be just $123.46 rounded up or down as the case may be?? If so, is there a simple way to do it? If a macro is required, I need the macro. I

    I would really appreciate if someone out there can help me with this.

    Thanks a million. You Excel experts and macro gurus have been great!!!
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,421
    First Name:
    Wayne
    try using =round
    Round( number, digits )

    can that be used
     
  3. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Be wary of cutting off fractions of pennies though. It should usually only be done for final calculations, or when dealing with real money values only, as they can add up to make big differences in final calculations.
     
  4. PincivMa

    PincivMa Thread Starter

    Joined:
    Mar 13, 2004
    Messages:
    378
    Thanks for the formula and the caution for rounding.

    Mario
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1030170

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice