View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sandip.dhamapurkar@gmail.com is offline
external usenet poster
 
Posts: 29
Default incorrect addition

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???