Excel 2011 - How can I change this VBA UDF to output numbers out to do decimal places (hundredths place)?

Asked Jul 07 '17 at 20:44

Active Jul 07 '17 at 20:44

Viewed 103 times

I'm trying to manipulate this UDF so the output shows the decimal values out to the hundredths place. Notice that the sum in cell G2 should read 30.50 (or 30.5) but its dropping the decimals. I've tried function CDbl and CCur, but doesn't seem to change output.

edited Jul 09 '18 at 19:34

Community

asked Jul 07 '17 at 20:44

Devil07

Just noticed, Change Dim total as long to a double. – Sorceri Jul 07 '17 at 20:58
no need too as I should have caught that the first time, my bad! – Sorceri Jul 07 '17 at 21:06
next time, please post the code here instead of showing it in an image – Gowtham Shiva Jul 08 '17 at 14:23
I will do that when I get back to my computer. – Devil07 Jul 08 '17 at 14:45

Excel 2011 - How can I change this VBA UDF to output numbers out to do decimal places (hundredths place)?

0 Answers0