D
David
I am updating a spreadsheet that has 13 worksheets, each with questions where
the user "grades" themselves by selecting numbers through a combo box. The
combo box refers to a range elsewhere on the sheet containing numbers such as
0, 1, 2.5, 5 etc. These numbers are formatted as numbers. When the user
selects a number, the result is posted to a hidden cell to the right of the
combo box. However, this number result is posted as text and the formula
=sum(L5:L19) will not update. =sum(L5+l6+l7+etc) does work, but we are adding
rows and having to manually updating each formula. We really prefer the
results be in number format and not text without having to convert to number
or number * 1. The combo box is not done through Data Validation...which I've
tried. What suggestions can someone offer? I've looked at doing a macro on
the page to do the conversion, but don't know how to assign to any change on
any combo box (all the combo boxes use the numbers, so that could be an
answer) as I don't want to write code for individual combo boxes as their
name may change as they are copied and added to the new rows.
the user "grades" themselves by selecting numbers through a combo box. The
combo box refers to a range elsewhere on the sheet containing numbers such as
0, 1, 2.5, 5 etc. These numbers are formatted as numbers. When the user
selects a number, the result is posted to a hidden cell to the right of the
combo box. However, this number result is posted as text and the formula
=sum(L5:L19) will not update. =sum(L5+l6+l7+etc) does work, but we are adding
rows and having to manually updating each formula. We really prefer the
results be in number format and not text without having to convert to number
or number * 1. The combo box is not done through Data Validation...which I've
tried. What suggestions can someone offer? I've looked at doing a macro on
the page to do the conversion, but don't know how to assign to any change on
any combo box (all the combo boxes use the numbers, so that could be an
answer) as I don't want to write code for individual combo boxes as their
name may change as they are copied and added to the new rows.