Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
caliskier
 
Posts: n/a
Default 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

  #2   Report Post  
cafe
 
Posts: n/a
Default


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

  #3   Report Post  
caliskier
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Columns Negative Numbers Upgrade Excel? Dust Bun Excel Discussion (Misc queries) 1 July 22nd 05 06:07 PM
Checking Winning Numbers in the Lottery. Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM
How do I extract numbers from many columns in excel on to one cel. DFALUSA Excel Worksheet Functions 3 March 3rd 05 01:48 AM
In Excel can you merge two columns i.e. street numbers and addres. Aaronhaus Excel Worksheet Functions 1 January 6th 05 01:34 PM
how to build a formula to match numbers in 2 columns with the equ. mcdilash Excel Worksheet Functions 1 November 10th 04 05:31 PM


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"