Thread: why does excel return a : when I put in a .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default why does excel return a : when I put in a .
The proper syntax is to use a colon, not a period. I think Excel
automatically corrects this for you -- the period syntax, I
believe, comes out of Lotus 123.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jose" wrote in message
...
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


Reply With QuoteReply With Quote