ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the columns from letters to numbers (https://www.excelbanter.com/excel-programming/325744-changing-columns-letters-numbers.html)

Mike

Changing the columns from letters to numbers
 
Hi all,

I'm just wondering if there's a quick setting that can be changed that will
show the column values as numbers rather than letters in a worksheet.

Any help would be greatly appreciated,

Thanks in advance,

Mike

Fredrik Wahlgren

Changing the columns from letters to numbers
 

"Mike" wrote in message
...
Hi all,

I'm just wondering if there's a quick setting that can be changed that

will
show the column values as numbers rather than letters in a worksheet.

Any help would be greatly appreciated,

Thanks in advance,

Mike


Tools|Settings. Select the "General" tab. Click on the R1C1 reference type
check box.

/Fredrik




All times are GMT +1. The time now is 06:00 PM.

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