Solved: Fixing currency to 2 decimal places

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

Not open for further replies.

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. etafModerator

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

can that be used

3. 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.

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

Mario

As Seen On