LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Junior Member
 
Posts: 27
Default

Follow these steps to change column from numeric to alphabet

Clear the R1C1 reference style selection in Excel preferences.
Difference between A1 and R1C1 reference styles

On the Excel menu, click Preferences.

Under Authoring, click General

Clear the Use R1C1 reference style check box.

The column headings now show A, B, and C, instead of 1, 2, 3, and so on.

I hope this is helpful!
Tim Paine
 
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
Column heading is numeric. How to change to Alphabet? Kubo Excel Discussion (Misc queries) 2 January 19th 10 04:20 AM
How to convert numeric(1) to alphabet (One) in Excell raghu Excel Discussion (Misc queries) 1 December 20th 07 10:39 AM
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
how to convert numeric into alphabet fong Excel Worksheet Functions 1 September 6th 05 02:48 AM


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