• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Round a Currency variable down

how can i round a number down ?
Dim mcurDollarValue As Currency
I have a currency variable that i display as either currency or long
how can i round this number down to the next whole number
eg:
39.6 = 39
0
isnoend2001
Asked:
isnoend2001
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
Use the Int function.
0
 
Martin LissOlder than dirtCommented:
Int(39.6) yields 39
0
 
isnoend2001Author Commented:
Thanks
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now