ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Alpha Numeric tab not showing only numeric. (https://www.excelbanter.com/excel-worksheet-functions/115375-alpha-numeric-tab-not-showing-only-numeric.html)

Inachu

Alpha Numeric tab not showing only numeric.
 
I tried to look in the sub menus to change this back to
Alphanumeric but every change I made did not take.

Any way to force Excel back to it's original settings?

Dave Peterson

Alpha Numeric tab not showing only numeric.
 
Does this mean you see numbers instead of letters for the column headings?

If yes:
Tools|options|General Tab|uncheck the R1C1 reference style box.



Inachu wrote:

I tried to look in the sub menus to change this back to
Alphanumeric but every change I made did not take.

Any way to force Excel back to it's original settings?


--

Dave Peterson

Jon von der Heyden

Alpha Numeric tab not showing only numeric.
 
Not sure if I follow you? Tab? I usually associate tab with worksheet.
Or do you mean column title? Tools-Options-General and then uncheck R1C1
reference style.
--
Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...


"Inachu" wrote:

I tried to look in the sub menus to change this back to
Alphanumeric but every change I made did not take.

Any way to force Excel back to it's original settings?



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

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