LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I change the Excel Column Labels as back to alpha?

ToolsOptionsGeneral.

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 15:28:02 -0700, CherylJ
wrote:

Several Files I have received from people have the rows and columns BOTH in
numerics instead of the rows in numeric and the columns in ALPHA. It screws
up formulas so I do I seitch them back?


 
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
What causes column headings in Excel to change from A, B, to 1,2? Richard Excel Discussion (Misc queries) 1 June 29th 06 06:22 PM
Change the column designation from a numeric to an alpha George Sladky Excel Discussion (Misc queries) 2 May 4th 06 02:47 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2000 - Column labels for forms Abay New Users to Excel 2 August 23rd 05 02:23 AM
Columns are now numeric, not alpha. how to change back? samriepe Excel Discussion (Misc queries) 1 June 9th 05 03:17 PM


All times are GMT +1. The time now is 02:44 AM.

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

About Us

"It's about Microsoft Excel"