ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   columns showing numbers instead of alphabets (https://www.excelbanter.com/excel-discussion-misc-queries/127841-columns-showing-numbers-instead-alphabets.html)

inenewbl

columns showing numbers instead of alphabets
 
Hi all. In my excel sheet, all the columns are showing numbers instead of
alphabets, eg 1,2,3... instead of A,B,C... Why is this so? How can i change
them back to show alphabets? Thks in advance.

Ron Coderre

columns showing numbers instead of alphabets
 
Try this:

From the Excel main menu:
<tools<options<general tab
UNcheck: R1C1 Reference style

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"inenewbl" wrote:

Hi all. In my excel sheet, all the columns are showing numbers instead of
alphabets, eg 1,2,3... instead of A,B,C... Why is this so? How can i change
them back to show alphabets? Thks in advance.



All times are GMT +1. The time now is 07:08 PM.

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