columns show as numbers

J

jbv

I just noticed that all of my columns now show up as numbers instead of letters, which makes it difficult for entering formulas - how do I get the columns back to letters
 
P

Peo Sjoblom

Tools>options>general and uncheck R1C1 reference style

--

Regards,

Peo Sjoblom

jbv said:
I just noticed that all of my columns now show up as numbers instead of
letters, which makes it difficult for entering formulas - how do I get the
columns back to letters
 
T

tjtjjtjt

Check in the Tools-->Options Dialog box on the General Tab. If R1C1 has a check next to it, remove it.

tj
 
Top