| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numerical columns
When I open Excel, my column labels are numerical instead of alphabetical and
I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
ToolsOptionsGeneral tab, uncheck R1C1 reference style
-- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
Click on Tools | Options | General tab, then uncheck R1C1 Reference
style. Hope this helps. Pete On Sep 23, 3:57*pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. *Every work sheet that I open is the same. I am using Office 2003. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
Thank you for you quick reply. It worked!
"Pete_UK" wrote: Click on Tools | Options | General tab, then uncheck R1C1 Reference style. Hope this helps. Pete On Sep 23, 3:57 pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
Thank you for your quick reply. It worked!
"Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
Thank you for your quick reply. It worked!
"Roger Govier" wrote: Hi Billie toolsoptionsgeneraluntick R1C1 reference style -- Regards Roger Govier "Billie" wrote in message ... When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
Thanks for the feedback, Billie - always appreciated.
Pete On Sep 23, 4:32*pm, Billie wrote: Thank you for you quick reply. *It worked! "Pete_UK" wrote: Click on Tools | Options | General tab, then uncheck R1C1 Reference style. Hope this helps. Pete On Sep 23, 3:57 pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. *Every work sheet that I open is the same. I am using Office 2003.- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
A futher idea on this question: Can these Columns be edited to display a
desired text? "Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numerical columns
No. But you can Hide them and use Row 1 for your text
Jeff wrote: A futher idea on this question: Can these Columns be edited to display a desired text? "Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and numerical values in two columns | Excel Discussion (Misc queries) | |||
| How do I sort multiple columns of of numerical and alphanumerical. | New Users to Excel | |||
| how do you change excel columns from numerical to alpha | Excel Discussion (Misc queries) | |||
| How do I merge 2 columns of numerical data? | Excel Discussion (Misc queries) | |||
| columns are numerical insted of alphabetical | Excel Discussion (Misc queries) | |||
Linear Mode
