Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Blairlyng
 
Posts: n/a
Default how do I cahnge column headings from numbers to letters


  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

ToolsOptions, General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Blairlyng" wrote in message
...



  #3   Report Post  
Andy Wiggins
 
Posts: n/a
Default

Tools Options: General, then uncheck "R1C1 reference style", and click on
OK

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Blairlyng" wrote in message
...



  #4   Report Post  
KL
 
Posts: n/a
Default

Hi,

menu ToolsOptions, tab 'General', uncheck option 'R1C1 reference style'.

Regards,
KL

"Blairlyng" wrote in message
...



  #5   Report Post  
Blairlyng
 
Posts: n/a
Default

Thank you so much Niek, you have saved my day. feel free to e-mail me when
you want to visit Scotland paul

"Niek Otten" wrote:

ToolsOptions, General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Blairlyng" wrote in message
...




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
automatically adjust numbers in a column when data is deleted Robbie Excel Worksheet Functions 2 May 21st 05 01:57 AM
why have column letters changed to numbers in excel JCereda Excel Discussion (Misc queries) 1 May 5th 05 12:36 PM
add only positive numbers and avg in a column rich Excel Worksheet Functions 6 March 10th 05 09:19 AM
Column Headings spencer4hire Excel Discussion (Misc queries) 2 March 9th 05 12:39 AM
Column Headings are numbers McMahon New Users to Excel 1 March 8th 05 11:38 PM


All times are GMT +1. The time now is 10:34 AM.

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"