Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 205
Default worksheet has numbers where the letters are on top of the columns

how do i get the letters back on top of the columns. some how they have
changed to numbers like on the rows.

thanks,
--
Linda
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default worksheet has numbers where the letters are on top of the columns

Tools Options General clear the R1C1 checkbox
--
Gary''s Student - gsnu200775


"Linda" wrote:

how do i get the letters back on top of the columns. some how they have
changed to numbers like on the rows.

thanks,
--
Linda

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,069
Default worksheet has numbers where the letters are on top of the columns

In Excel 2003 & prior, select Tools Options. On the General tab, uncheck
'R1C1 reference style'. Click OK.

Hope this helps,

Hutch

"Linda" wrote:

how do i get the letters back on top of the columns. some how they have
changed to numbers like on the rows.

thanks,
--
Linda

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default worksheet has numbers where the letters are on top of the columns

Tools/ Options/ General:
Uncheck: R1C1 reference style
--
David Biddulph

"Linda" wrote in message
...
how do i get the letters back on top of the columns. some how they have
changed to numbers like on the rows.

thanks,
--
Linda



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
Why have my Excel columns become numbers not letters? JoJoDunn Excel Discussion (Misc queries) 4 January 23rd 08 08:47 PM
columns appear as numbers not letters Clairey Excel Discussion (Misc queries) 2 June 30th 06 11:15 AM
I have numbers instead of letters on my columns, why? lisawjs Excel Discussion (Misc queries) 3 October 20th 05 07:18 PM
Help, my columns now have numbers instead of letters. caliskier Excel Discussion (Misc queries) 2 August 11th 05 02:55 PM
Columns in letters vs numbers garyflood Excel Discussion (Misc queries) 1 April 22nd 05 03:21 PM


All times are GMT +1. The time now is 01:43 AM.

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"