hi
did your program you use at work export the data to excel as text?????
sounds like it. you cannot add or apply number formats to text.
test.
somewhere on the sheet (anywhere), enter a 1(one). copy it.
high light some data then paste special multiply.
if your data is numbers stored as text, that should remove the text format.

Regards
FSt1

"camri6" wrote:

I exported some data from a program I use at work. the whole spreadsheet has
cells filled with percentages that I can't format, add together, etc.. I try
to add them together using the Sum function but it keeps kicking out 0.0%....
The sheet/workbook is not protected. Can anyone help