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

"JonnyE" wrote:

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.

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

JonnyE wrote:

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.

--

Dave Peterson

Try

Tools Options and on "general" tab untick "R1C1 reference style"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=518088