| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
| compare and find similar numbers in two columns | New Users to Excel | |||
| Columns showing up as thin vertical lines | Excel Discussion (Misc queries) | |||
| identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
Hybrid Mode
