Thread: Why does Excel return a : when I insert a .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
  
Posts: 430
Default Why does Excel return a : when I insert a .
It's probably some kind of automated error checking under
'tools'...options'...error checking.

Why would want to have the formula you have there? Are you trying to add
the contents of A1 to .22? (=A1+.22)

"Jose" wrote:

Does anyone know why when I enter =SUM(A1.22) Excel 2003 automatically
changes it to =SUM(A1:22)
Reply With QuoteReply With Quote