Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > how to change the alphabets to numbers and numbers to alphabets in
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 68
Default how to change the alphabets to numbers and numbers to alphabets in
Hi,

When I opened the new spreadsheet i am seeing by default the column names
has been changed to the numbers. Now I need to bring it down to the
Alphabets back.

Could you please let me know how to change the column names from numbers to
alphabets and alphabets to numbers.

Regards,
Igneshwara reddy
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,268
Default how to change the alphabets to numbers and numbers to alphabets in
Toolsoptionsgeneral and deselect R1C1 reference style


--


Regards,


Peo Sjoblom



"Igneshwara reddy" wrote in
message ...
Hi,

When I opened the new spreadsheet i am seeing by default the column names
has been changed to the numbers. Now I need to bring it down to the
Alphabets back.

Could you please let me know how to change the column names from numbers
to
alphabets and alphabets to numbers.

Regards,
Igneshwara reddy


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 964
Default how to change the alphabets to numbers and numbers to alphabets in
In Excel 2003 or earlier:
TOOLS
OPTIONS
GENERAL Tab
Uncheck "R1C1 reference style"

In Excel 2007:
OFFICE Button
EXCEL OPTIONS
FORMULAS section
Uncheck "R1C1 reference style"

HTH,
Elkar


"Igneshwara reddy" wrote:

Hi,

When I opened the new spreadsheet i am seeing by default the column names
has been changed to the numbers. Now I need to bring it down to the
Alphabets back.

Could you please let me know how to change the column names from numbers to
alphabets and alphabets to numbers.

Regards,
Igneshwara reddy
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
How to make the First alphabets in the cell to be blank. Igneshwara reddy[_2_] Excel Worksheet Functions 7 July 3rd 07 08:48 PM
how do i change column numbers to alphabets from numerals C Excel Discussion (Misc queries) 2 June 12th 07 11:03 PM
columns showing numbers instead of alphabets inenewbl Excel Discussion (Misc queries) 1 January 26th 07 12:36 PM
Fill alphabets shibu Excel Discussion (Misc queries) 1 January 3rd 07 07:47 AM
In Excel up sides alphabets change into newmaric ASHISH R. MAROO Setting up and Configuration of Excel 1 May 5th 06 06:38 PM


All times are GMT +1. The time now is 09:59 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"

 

Contact Us ExcelBanter forum home Privacy Statement