Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
LM LM is offline
external usenet poster
 
Posts: 21
Default Column header changed to numbers, how do I change to letters?

On my spreadsheet (version 2003) the column header has changed to numbers.
Does anyone know how to change it back to letters?
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3,440
Default Column header changed to numbers, how do I change to letters?

ToolsOptionsGeneral tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LM" wrote in message
...
On my spreadsheet (version 2003) the column header has changed to numbers.
Does anyone know how to change it back to letters?


  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default Column header changed to numbers, how do I change to letters?

I need the answer to this same question, on a file I created in Office 2003
at work and brought home to my home computer which is Vista and Office for
Vista (not sure what the year is...maybe 2007?) It's a Dell computer.

"Niek Otten" wrote:

ToolsOptionsGeneral tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LM" wrote in message
...
On my spreadsheet (version 2003) the column header has changed to numbers.
Does anyone know how to change it back to letters?


  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3,440
Default Column header changed to numbers, how do I change to letters?

If it is Excel 2007:

Office button (Large round button top left)Excel optionsFormulas
tabWorking with formulasUncheck R1C1 Reference style
If not Excel 2007: I gave you the answer already

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BonnieR" wrote in message
...
I need the answer to this same question, on a file I created in Office 2003
at work and brought home to my home computer which is Vista and Office for
Vista (not sure what the year is...maybe 2007?) It's a Dell computer.

"Niek Otten" wrote:

ToolsOptionsGeneral tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LM" wrote in message
...
On my spreadsheet (version 2003) the column header has changed to
numbers.
Does anyone know how to change it back to letters?



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
How to Change Column Header from numbers back to letters Luke Excel Worksheet Functions 2 July 29th 08 09:40 PM
Column references changed from letters to numbers JoAnn New Users to Excel 2 June 3rd 08 03:03 PM
column headers changed from letters to numbers, how do I change ba B Lutz Excel Discussion (Misc queries) 1 April 27th 08 02:58 AM
why have column letters changed to numbers in excel JCereda Excel Discussion (Misc queries) 1 May 5th 05 12:36 PM
My excell column letters have changed to numbers. I don't want th. Kristi Excel Worksheet Functions 2 February 21st 05 11:05 PM


All times are GMT +1. The time now is 07:23 AM.

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

About Us

"It's about Microsoft Excel"