Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / July 2006

Tip: Looking for answers? Try searching our database.

Why does Excel return a : when I insert a .

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jose - 14 Jul 2006 19:30 GMT
Does anyone know why when I enter =SUM(A1.22) Excel 2003 automatically
changes it to   =SUM(A1:22)
tim m - 14 Jul 2006 20:53 GMT
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)

> Does anyone know why when I enter =SUM(A1.22) Excel 2003 automatically
> changes it to   =SUM(A1:22)
Kevin Vaughn - 14 Jul 2006 21:17 GMT
What is A1.22?  When I try it, I get a #NAME error.  This is just a guess
based on what I know could happen.  Is it possible you are entering
=sum(a1..a11) (notice the 2 dots.)  This is how you would enter a formula
using Lotus 123.  Excel recognizes this and allows it but changes it to the
format that it uses for the sum function; =sum(a1:a22)

Actually, I just tested and it also did it when I entered just one period.  
I.e. it changed =sum(a1.a22) to =sum(a1:a22).  I suspect it is for the same
reason, but do not have any proof.

When I used to use Lotus all those years ago, I always used two dots.  I
don't know what would happen using only one dot (especially with later
versions.)
Signature

Kevin Vaughn

> Does anyone know why when I enter =SUM(A1.22) Excel 2003 automatically
> changes it to   =SUM(A1:22)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.