why does excel return a : when I put in a .
Why would you put a decimal point(period) in the formula?
Excel does not recognize that as a valid entry so assumes you mean A1:A22
Maybe you meant =SUM(A1,A22)
Gord Dibben MS Excel MVP
On Fri, 14 Jul 2006 11:15:01 -0700, Jose wrote:
Does anyone know why when I enter =SUM(A1.A22)
Excel 2003 automatically changes the formula to =SUM(A1:A22)
I would be grateful for feedback
Thanks
|