View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default incorrect addition

Total.Value = Sum(Contents.Value, Bldg.Value)

wrote in message
ps.com...
I have three textboxes:
Contents Premium name:contents
Bldg Premium name:bldg
Total Premium name:total

Total.Value = Contents.Value + Bldg.Value
When I add the above line to calculate the total premium, it does not
add, it concatenates. eg. if I put 10000 in Contents Premium and 50 in
Bldg Premium, ideally it should show 10050 but it is showing 1000050

Total.Value = Contents.Value - Bldg.Value
The above line for subtracting works fine.

Any ideas???