Solved: ROUND FUNCTION

[stecstec]

Hi there,

This hopefully will be quick solution - I'm trying to use the Round function to have a result which should be displayed as a currency value. I've noticed sometimes that the result can be "30.5" - is there any why of tweaking the result so I get it as "30.50"?


n4 = Round((n4 / 12), 2)


Would appreciate a quick response on this! Many thanks, Steve.

[fumei]

Try using FormatCurrency.

MsgBox FormatCurrency(32.5) will display $32.50

n4 = FormatCurrency(Round((n4 / 12), 2) )

[stecstec]

Try using FormatCurrency.

MsgBox FormatCurrency(32.5) will display $32.50

n4 = FormatCurrency(Round((n4 / 12), 2) )

Thanks Gerry, unfortunately this doesnt seem to work for me - I still get 32.5

I've got n4 set as Double to allow the decimal places - would this be correct?

thanks again, Steve.

[fumei]

No. Please post as full as possible code.

[stecstec]

Gerry,

- have got the code to work, I didnt realise the output needed to be a string! (must be an off-day..)

Many thanks for your help on this. :friends:

Steve.

[fumei]

Ah, yes...it is a string.