column changed from alpha to numeric
 

Hi ,

i am using excel 97.

the column heading used to be A , B , C etc.. now it has somehow been
changed to 1 , 2 , 3 ... 256

could anyone give me some idea how i can change it back ?

tks & rdgs

Tools Options General
Uncheck box for R1C1reference style

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376223

Hello Maxzsim,

Goto "Tools" -- "Option" -- tab "General" -- remove checkmark for "R1C1
reference style".

HTH,
CoRrRan

On Thu, 2 Jun 2005 23:56:03 -0700, maxzsim wrote:

Hi ,

i am using excel 97.

the column heading used to be A , B , C etc.. now it has somehow been
changed to 1 , 2 , 3 ... 256

could anyone give me some idea how i can change it back ?

tks & rdgs