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 |
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 |
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