software

Using Excel 2000, my columns are arranged by number and not letters, so that
if I'm trying to create a formula to add cells A5 and B6, I get a #NAME ?
error because it does not see a cell A5 or B6, it sees R5C1/R6C2. Some way
to change this would be greatly appreciated.

whoops.. found the answer in the setup section, I'm good

quot;JonnyEquot; wrote:

gt; Using Excel 2000, my columns are arranged by number and not letters, so that
gt; if I'm trying to create a formula to add cells A5 and B6, I get a #NAME ?
gt; error because it does not see a cell A5 or B6, it sees R5C1/R6C2. Some way
gt; to change this would be greatly appreciated.

Tools|Options|general tab|Uncheck the R1C1 Reference style.

JonnyE wrote:
gt;
gt; Using Excel 2000, my columns are arranged by number and not letters, so that
gt; if I'm trying to create a formula to add cells A5 and B6, I get a #NAME ?
gt; error because it does not see a cell A5 or B6, it sees R5C1/R6C2. Some way
gt; to change this would be greatly appreciated.

--

Dave Peterson


Try

Tools gt; Options and on quot;generalquot; tab untick quot;R1C1 reference stylequot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=518088