why are my columns labelled with numbers?
 

Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.

why are my columns labelled with numbers?
 

Tools|Options|General tab|Uncheck R1C1 reference style.

This setting is picked up from the first workbook you open in the session. If
you're unlucky, you may have to change this again. So you'll want to remember
it.

ec17 wrote:

Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.

--

Dave Peterson

why are my columns labelled with numbers?
 

Try this:

From the Excel main menu:
<tools<options<general tab
Uncheck: R1C1 reference style

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ec17" wrote:

Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.

why are my columns labelled with numbers?
 

hi,
on the tool bar go to Toolsoptionsgeneral tab
uncheck R1C1 reference style.

regards
FSt1

"ec17" wrote:

Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.

why are my columns labelled with numbers?
 

<Tools <Options <General tab,
and *UNCHECK*
"R1C1 reference style".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"ec17" wrote in message
...
Instead of having columns labelled A, B, C etc, my columns are labelled
1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.