MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COLUMN LETTERS


Posted by Al P{olan on November 05, 2000 11:31 AM

Some how all of my column letters have changed to numbers, What did I do and how can I correct it.


Posted by Daniel Stone on November 05, 2000 2:34 PM

I suspect that R1C1 is enabled. Go to Tools->Options... , then the Genral Tab, then see if the R1C1 reference check box is ticked, if so untick it. Hope thats it.