| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How could my column labels become numbers instead of letters???
I am working on a finance document with about 40 columns by over 100 rows. I
don't know how but the column titles now read as numbers instead of letters. I have tried beginning a new document with the same data, but this too has now changed (overnight). does anyone have any ideas how this occured?? Ruth |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How could my column labels become numbers instead of letters???
In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style Excel picks up this setting from the first workbook you open in that session. Ruth wrote: I am working on a finance document with about 40 columns by over 100 rows. I don't know how but the column titles now read as numbers instead of letters. I have tried beginning a new document with the same data, but this too has now changed (overnight). does anyone have any ideas how this occured?? Ruth -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How could my column labels become numbers instead of letters???
thankyou Dave, that worked
"Ruth" wrote: I am working on a finance document with about 40 columns by over 100 rows. I don't know how but the column titles now read as numbers instead of letters. I have tried beginning a new document with the same data, but this too has now changed (overnight). does anyone have any ideas how this occured?? Ruth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 change column labels from numbers to letters | Setting up and Configuration of Excel | |||
| How do I change the labels of my columns from numbers to letters? | Excel Discussion (Misc queries) | |||
| How do I change the labels of my columns from numbers to letters? | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters? | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
