Forum Discussion
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
JoeUser2004 MANY THANKS!
I UNDERSTAND THE ERROR, and know how to fix it cell by cell.
Still did not get how to force a group of cells to convert from text (or anything) to %.
THANKS AGAIN, ilan
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?
- YES!!!
THANK YOU!!!
