what could cause numbers to appear as row names and column names
 

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
...

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
...

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
...