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

106 views Asked by At

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.

textjoinsum digits

0

There are 0 answers