| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column references changed from letters to numbers
I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so
other folks can add a single row of information to the list. Somehow, the column references changed from A, B, C ... to 1,2,3 ... while the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet corrupt? Anyone know how this could have happened ... and how do I change it back? The sheet was protected and the folks entering the data didn't have the password. Is there some way to prevent it from happening again? Thanks, -- JoAnn |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column references changed from letters to numbers
Tools - Options - General Tab. Uncheck R1C1 Reference style
"JoAnn" wrote: I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so other folks can add a single row of information to the list. Somehow, the column references changed from A, B, C ... to 1,2,3 ... while the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet corrupt? Anyone know how this could have happened ... and how do I change it back? The sheet was protected and the folks entering the data didn't have the password. Is there some way to prevent it from happening again? Thanks, -- JoAnn |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column references changed from letters to numbers
Thanks, Dennis! That solved the problem.
-- JoAnn "Dennis" wrote: Tools - Options - General Tab. Uncheck R1C1 Reference style "JoAnn" wrote: I have a tracking list in an Excel 2003 spreadsheet (posted in Sharepoint) so other folks can add a single row of information to the list. Somehow, the column references changed from A, B, C ... to 1,2,3 ... while the row references are still at 1,2,3 ... Is this valid? Or is my spreadsheet corrupt? Anyone know how this could have happened ... and how do I change it back? The sheet was protected and the folks entering the data didn't have the password. Is there some way to prevent it from happening again? Thanks, -- JoAnn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column headers changed from letters to numbers, how do I change ba | Excel Discussion (Misc queries) | |||
| Excel 2007 changed the column Letters into numbers | Excel Discussion (Misc queries) | |||
| why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
| the letters across the top in excel have changed to numbers why | New Users to Excel | |||
| My excell column letters have changed to numbers. I don't want th. | Excel Worksheet Functions | |||
Linear Mode
