Number format problem

Originally Posted by shg

Select col F and click the left-align button TWICE. The values that are (now) left justified are text.

Enter 0 in a cell, copy it, select the data in col F, Paste Special, Add.

By changing away from Excel's default horizontal alignment, you lose a lot of information. Bad idea.

Hi, I just did what you said, still not working. I don't know if you tried it yourself and solved the problem, but if you did send me the file please. It keeps giving me the #VALUE! error when I try to make a calculation with it.