| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I'm adding 1.5 & 1 and VBA is telling me its 2 ?!?!
I'm trying to find a way to have VBA give me the sum of multiple non-integers
to the 2nd decimal place. So far, I'm having no luck. I thought formatting the variable using "#,###.##" might work, but for the sum of 1.5 & 1 it gives me 2. (It doesn't give me 2.00, just 2. with a lone decimal place after the 2) What can I do to get VBA to recognize the decimal places? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| telling range when to stop. | Excel Programming | |||
| Telling a website what to do!! | Excel Programming | |||
| Telling a procedure to end | Excel Programming | |||
| Telling MSGraph which cell I need | Excel Programming | |||
| telling Excel to go down relatively | Excel Programming | |||
Threaded Mode
