ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help, my columns now have numbers instead of letters. (https://www.excelbanter.com/excel-discussion-misc-queries/39903-help-my-columns-now-have-numbers-instead-letters.html)

caliskier

Help, my columns now have numbers instead of letters.
 

A coworker asked me to help him with his excel file. He opened a file
that had numbers instead of letters in the column labels, now he is
seeing it in other files he linked that file to. How do you change it
back? The name box even says R34C7 or R23C90 for Row and Column.


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=394941


cafe


In excel menu select Tools/Options goto to the general tab and in the
settings the *R1C1 Reference Style* should not be selected.

Regards,


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=394941


caliskier


Thanks, I looked there but not very hard.


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=394941



All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com