Forum Discussion
Solved
Decimal Places Difficulty
Hi As can be seen in the attachment, I have the display set to currency and to two decimal places but the values show as .00 instead, such as 10/3 should read 3.33 but displays 3.00. So, how can ...
- Hi
So per the screenshot you would type
=F55/G55
OK, thanks.
I am just a basic user of Excel and used quotient because it's the first one I came across that would divide one number into another.
So, is there a function I can use in currency that will include the decimal portion?
Thanks.
R
I am just a basic user of Excel and used quotient because it's the first one I came across that would divide one number into another.
So, is there a function I can use in currency that will include the decimal portion?
Thanks.
R
Hi
So per the screenshot you would type
=F55/G55
So per the screenshot you would type
=F55/G55
- That's done the trick. Thanks!
R