Display value in textbox format decimal places

Hello again

Getting very frustrated here, I can't seem to work out how to display the values to a certain number of decimal places (not concerned whether they're rounded or not)

incvat.Text = Range("'DATA'!R4")
lessvat.Text = Range("'DATA'!R5")
vat.Text = Range("'DATA'!R6")


For incvat, I need the number shown to read zero decimal places, and the others to two decimal places.

I have tried, copying and pasting the cell data using paste special "Value and Format", and although the cells display the correct amount of decimals, the actual value of the cell and textbox remain many decimals.

(For the record, the cells are formulas, not values)

Any ideas?

Many thanks

Alex

Try so:

Please Login or Register  to view this content.

I hope it can help.

Regards,
Antonio

Many thanks Antonio - works flawlessly