ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I change column from numeric to alphabet? (https://www.excelbanter.com/setting-up-configuration-excel/256902-how-do-i-change-column-numeric-alphabet.html)

wgfpshaky February 20th 10 02:27 PM

How do I change column from numeric to alphabet?
 
I have numbers in both columns and rows. I would like to have letters
accrosss the top.
Len

Dave Peterson February 20th 10 03:47 PM

How do I change column from numeric to alphabet?
 
In xl2003 menus:

Tools|Options|General Tab|uncheck R1C1 Reference style.

wgfpshaky wrote:

I have numbers in both columns and rows. I would like to have letters
accrosss the top.
Len


--

Dave Peterson

trip_to_tokyo[_3_] February 20th 10 07:24 PM

How do I change column from numeric to alphabet?
 
In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick in the box called:-

R1C1 reference style

If my comments have helped please hit Yes.

Thanks.



"Dave Peterson" wrote:

In xl2003 menus:

Tools|Options|General Tab|uncheck R1C1 Reference style.

wgfpshaky wrote:

I have numbers in both columns and rows. I would like to have letters
accrosss the top.
Len


--

Dave Peterson
.


Tim Paine January 1st 21 01:16 PM

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


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com