| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Decimal Values in Variable - Losing decimals when summin
I have a variable, "Current", that sums various dollar values from a range
based on certain criteria. However, when I report the total value of "Current", I get a value that has been rounded. Where I expected to receive 243.25, I get 243.00 What do I need to do to capture the actual value? Current is declared as Long |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing Decimal Values in Variable - Losing decimals when summin
Another board gave me the answer.
The sum is a currency, so Dim Current as Currency is an option, as is Dim current as Double "Mark" wrote: I have a variable, "Current", that sums various dollar values from a range based on certain criteria. However, when I report the total value of "Current", I get a value that has been rounded. Where I expected to receive 243.25, I get 243.00 What do I need to do to capture the actual value? Current is declared as Long |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Losing Values | Excel Discussion (Misc queries) | |||
| Protect worksheet - losing values | Excel Worksheet Functions | |||
| Summin Pivot Table data from a date selected in the Page field | Excel Discussion (Misc queries) | |||
| How can I change time format to decimal without losing hours? | Excel Discussion (Misc queries) | |||
| concatenating "00"&"00"&"01" without losing the zero values | Excel Worksheet Functions | |||
Linear Mode
