ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I change column headers from a number to a letter (https://www.excelbanter.com/excel-discussion-misc-queries/161744-how-do-i-change-column-headers-number-letter.html)

niffer

how do I change column headers from a number to a letter
 
I have a spreadsheet where instead of letters the columns are labeled with
numbers. Formulas still want the letter value though. How do I change them
back to the letters??

Rich[_2_]

how do I change column headers from a number to a letter
 
Tools: options : General

Take Tick Out Of The R1C1 Options Box

Rich



"niffer" wrote:

I have a spreadsheet where instead of letters the columns are labeled with
numbers. Formulas still want the letter value though. How do I change them
back to the letters??



All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com