Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
len len is offline
external usenet poster
 
Posts: 53
Default How do I set rows to Alpha and columns to numbers?

Columns and rows ar both numbers. How do I get the rows back to Apha and
leave the columns as numbers. Example identify a cell as C1
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default How do I set rows to Alpha and columns to numbers?

Len, tools, options, general, uncheck R1C1 ref. style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Len" wrote in message
...
Columns and rows ar both numbers. How do I get the rows back to Apha and
leave the columns as numbers. Example identify a cell as C1



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
both columns and rows are numeric.want the columns to be alpha Amy Setting up and Configuration of Excel 2 September 26th 06 09:16 PM
how do you change excel columns from numerical to alpha ronnie t blonde Excel Discussion (Misc queries) 2 May 16th 06 10:42 AM
Why are my excel worksheet columns are Numbered not Alpha Paula Excel Discussion (Misc queries) 3 June 20th 05 04:58 PM
Columns are now numeric, not alpha. how to change back? samriepe Excel Discussion (Misc queries) 1 June 9th 05 03:17 PM
My Excel columns are now denoted with numbers not letters, why? mjnemelka Excel Discussion (Misc queries) 1 June 1st 05 12:19 AM


All times are GMT +1. The time now is 10:45 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"