Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 19th 10, 02:21 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default Column heading is numeric. How to change to Alphabet?



  #2   Report Post  
Old January 19th 10, 02:34 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 698
Default Column heading is numeric. How to change to Alphabet?

This seems to sneak up on a few people...

Tools Options General uncheck R1C1 refrence style OK

HTH
Regards,
Howard

"Kubo" wrote in message
...



  #3   Report Post  
Old January 19th 10, 04:20 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,520
Default Column heading is numeric. How to change to Alphabet?

and if XL2007 check out this option at Office ButtonExcel Options
Formulas'Working with formulas' R1C1 reference style

--
Jacob


"L. Howard Kittle" wrote:

This seems to sneak up on a few people...

Tools Options General uncheck R1C1 refrence style OK

HTH
Regards,
Howard

"Kubo" 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
Can I change the column heading from alphabetic to numeric? Lunchbox18 Excel Discussion (Misc queries) 2 March 14th 09 06:30 AM
How do I change excel column heading from numeric to alphabetic? bones21 Excel Discussion (Misc queries) 3 January 30th 09 07:11 AM
how do I column heading to alpha from Numeric? Thessia Excel Discussion (Misc queries) 1 March 18th 08 10:21 PM
How can change column title back to alphabet (A,B,C..) Ray Excel Worksheet Functions 2 March 9th 07 02:52 AM
Worksheet Column Labels ... Alphabet or Numeric ? monir Excel Discussion (Misc queries) 1 April 6th 06 08:48 PM


All times are GMT +1. The time now is 04:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017