By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

access currency and decimals

P: 22
Hi all,

Im having trouble with currency formatting and the amount of decimals displayed. Most of my stored values are pretty standard ($10.50). Some item have a 4 decimal place cost though ($.0025). I have the table formatted to store 4 decimal places but when using the currency format it drops the last two places of the value. Is there a way around this or do i have to use general number format for the table? I also dont want the field to display 4 digits after the decimal if its not necessary. ($50.00 instead of $50.0000)
May 30 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

As format of your digits you should choose General with 2 decimal places... But when there is .00 the .00 not be shown also!

There is functions to do truncation

For exemple you can use the follow:

Int(My_number*100+0.5)/100

So if your nember is 105.002
then 10500.2+0.5=10500.7
after int it gives 10500 then / 100 = 105.00 :)
Sep 3 '06 #2

100+
P: 179
There's something I'm not understanding here. Why do you have your table set up to display 4 decimal places, when you only want 2 for your currency?

comteck
Sep 5 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.