Forum Discussion
ibauminger
May 10, 2023Copper Contributor
Excel sum precente
Using =SUM(A1:A2) to add 2 cells including precentage figure such as 0.61% and -0.31% I get the value 0.00% . What am I doing wrong? Thanks, ilan
HansVogelaar
May 13, 2023MVP
Select a column with such values.
On the Data tab of the ribbon, click Text to Columns.
Click Delimited, then click Finish.
Does that help?
ibauminger
May 13, 2023Copper Contributor
YES!!!
THANK YOU!!!
THANK YOU!!!