Columns are in numbers

[Guest]

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.

 

[Guest]

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

 

[Dave Peterson]

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

 

[daddylonglegs]

Try

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