Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default what could cause numbers to appear as row names and column names


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The column names (A,B,C, etc...) changed to numbers?????????? Jenner Setting up and Configuration of Excel 1 May 27th 09 06:53 PM
why are column names are numbers instead of letters Arlene[_2_] Excel Discussion (Misc queries) 2 November 19th 08 05:29 PM
Replacing A,B,C column names to other names Lisa H Excel Discussion (Misc queries) 4 July 11th 07 06:28 PM
Why are column names in numbers instead of characters? Harsha Excel Discussion (Misc queries) 1 February 6th 06 01:51 PM
sorting names alphabetically when names may start with numbers John Smith Excel Discussion (Misc queries) 3 May 11th 05 08:06 PM


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"