ExcelBanter - Format of column need to change back to Alpha not numeric

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format of column need to change back to Alpha not numeric (https://www.excelbanter.com/excel-discussion-misc-queries/139227-format-column-need-change-back-alpha-not-numeric.html)

nadine

Format of column need to change back to Alpha not numeric

Hi,

Can any one help me . My excel has changed the columns display format to
numeric and i need to change it back to alpha.
--
Nadine

JE McGimpsey

Format of column need to change back to Alpha not numeric

Tools/Options/General uncheck the R1C1 reference style checkbox.

In article ,
nadine wrote:

Hi,

Can any one help me . My excel has changed the columns display format to
numeric and i need to change it back to alpha.

Mike[_2_]

Alpha Numeric Columns

Just found this site and it helped immediately! Thanks.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

All times are GMT +1. The time now is 05:37 AM.