ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Somehow my spreadsheets have numbers instead of letters, why? (https://www.excelbanter.com/excel-discussion-misc-queries/195338-somehow-my-spreadsheets-have-numbers-instead-letters-why.html)

David Q

Somehow my spreadsheets have numbers instead of letters, why?
 
How do I change it back??



FSt1

Somehow my spreadsheets have numbers instead of letters, why?
 
hi
most probably one of your settings has slipped. it happens now and then.
on the menu bar...
tooloptionsGeneral tabuncheck r1c1 reference styleok

Regards
FSt1

"David Q" wrote:

How do I change it back??



Suleman Peerzade[_2_]

Somehow my spreadsheets have numbers instead of letters, why?
 
Hi David,

When you open your workbook go to toolsoptionsGeneralUncheck R1C1
reference style.

This will solve your problem.
--
Thanks
Suleman Peerzade


"David Q" wrote:

How do I change it back??




All times are GMT +1. The time now is 12:49 AM.

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