| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro | Excel Discussion (Misc queries) | |||
| Standard font in a "New Microsoft Excel Worksheet.xls" wont change | Excel Discussion (Misc queries) | |||
| How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions | |||
| Error msg "Microsoft Excel is waiting for another application to complete an OLE action" | Excel Programming | |||
Threaded Mode
