View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jamie@cd-worx.com is offline
external usenet poster
 
Posts: 4
Default How do you "Round" a value in Microsoft Excel VB?

Hi,

I have a number like 2.138 which I want to round to two decimal
places.

What is the command to do this?

Within a spreadsheet it's round(2.138,2) but this does not seem to
work in VBA.

I had read somewhere that all excel spreadsheet commands work within
VBA but this doesn't seem to be true. Can anyone elaborate?

Thanks guys.