Column heading display numbers not letters

S

Sandy

After opening an attached WS Excel now shows column number instead of
letters, which makes the formulas imposible to figure out

Help
 
J

John C

Go to menu Tools|Options|General tab, ensure the R1C1 reference style box is
not checked.
 
S

Stefi

Tools>Options>General tag, uncheck R1C1 Reference style checkbox!
Regards,
Stefi


„Sandy†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove numbers from brackets 0
Problem with SET & REF function 0
VBA - exporting serial letters to single documents 0
Word VBA Copy Heading and Content 4
Column Heading Error 3
Mail Merge Help 1
Excel does not accept text format! 0
in excel, workbook column heading is displaying numbers not lette. 2

Top