hi
is there a formula that will calculate a sum of just the numbers and ignore the percentage symbol for ex
i have numbers in cells that looks like this
4%
10.00%
5%
8%
i would like to just sum up all the numbers and ignore the percentage symbol
is there a formula that will calculate a sum of just the numbers and ignore the percentage symbol for ex
i have numbers in cells that looks like this
4%
10.00%
5%
8%
i would like to just sum up all the numbers and ignore the percentage symbol