Solved: Fixing currency to 2 decimal places

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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!!!
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,486
try using =round
Round( number, digits )

can that be used
 
Joined
Jul 25, 2004
Messages
5,458
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Members online

Top