Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what could cause numbers to appear as row names and column names
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what could cause numbers to appear as row names and column names
lexie61 -
what could cause numbers to appear as row names and column names < pre-2007 Excel: Tools | Options | General | R1C1 reference style Excel 2007: Office Button | Excel Options | Formulas | R1C1 reference style Excel 2010 Beta: File | Options | General | Formulas | R1C1 reference style - Mike http://www.MikeMiddleton.com "lexie61" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what could cause numbers to appear as row names and column names
It is always better to use all that blank white space in the body of the
message to describe in non-cryptic, non-abbreviated detail what your problem/question is so we don't have to struggle to guess at what you want. Taking a guess based on the limited data you posted... click Tools/Options on the menu bar, select the General tab and uncheck the first CheckBox (labeled "R1C1 reference style"). Did that solve your problem? -- Rick (MVP - Excel) "lexie61" wrote in message ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what could cause numbers to appear as row names and column names
Check this setting:
In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK out Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out -- Biff Microsoft Excel MVP "lexie61" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The column names (A,B,C, etc...) changed to numbers?????????? | Setting up and Configuration of Excel | |||
why are column names are numbers instead of letters | Excel Discussion (Misc queries) | |||
Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
Why are column names in numbers instead of characters? | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |