Home |
Search |
Today's Posts |
#1
|
|||
|
|||
columns changing to numbers
I opened a worksheet this afternoon and found that the column headings have
changed from alpha characters to numerals. Now all my worksheets are reflecting numerals in the columns. Has anyone seen this before or know what I can do to fix it? Thanks, Pablo |
#2
|
|||
|
|||
You probably didn't look at your formulas. If you did, you'd be even more
distressed. Go to Tools/Options/General and uncheck "R1C1 Reference Style". On Fri, 4 Mar 2005 14:49:02 -0800, "Pablo" wrote: I opened a worksheet this afternoon and found that the column headings have changed from alpha characters to numerals. Now all my worksheets are reflecting numerals in the columns. Has anyone seen this before or know what I can do to fix it? Thanks, Pablo |
#3
|
|||
|
|||
Pablo
Tools | Options | General tab | Settings section | switch off R1C1 reference style Regards Trevor "Pablo" wrote in message ... I opened a worksheet this afternoon and found that the column headings have changed from alpha characters to numerals. Now all my worksheets are reflecting numerals in the columns. Has anyone seen this before or know what I can do to fix it? Thanks, Pablo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of all even and odd numbers between two columns | New Users to Excel | |||
How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
I have Excel columns with different statements (yes, no; numbers). | Excel Worksheet Functions |