software

While merging data from different worksheets and formatting cells, I suddenly
noticed the column identifiers at the top of my worksheet changed to numbers
instead of letters. Any good ideas on how I should change them back to
letters? I searched Help Online and came up empty thus far. Thanks!


Hello Cotmc,

On the the menu go to Toolsgt;Optionsgt;Generalgt;Settings and click the box
marked R1C1 style to clear it.

Sincerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=503418Try this:

Toolsgt;Optionsgt;General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;cotmcquot; wrote:

gt; While merging data from different worksheets and formatting cells, I suddenly
gt; noticed the column identifiers at the top of my worksheet changed to numbers
gt; instead of letters. Any good ideas on how I should change them back to
gt; letters? I searched Help Online and came up empty thus far. Thanks!

Yes! Thanks a million!

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Toolsgt;Optionsgt;General tab
gt; UNcheck: R1C1 reference style
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;cotmcquot; wrote:
gt;
gt; gt; While merging data from different worksheets and formatting cells, I suddenly
gt; gt; noticed the column identifiers at the top of my worksheet changed to numbers
gt; gt; instead of letters. Any good ideas on how I should change them back to
gt; gt; letters? I searched Help Online and came up empty thus far. Thanks!

Thanks!!

quot;Leith Rossquot; wrote:

gt;
gt; Hello Cotmc,
gt;
gt; On the the menu go to Toolsgt;Optionsgt;Generalgt;Settings and click the box
gt; marked R1C1 style to clear it.
gt;
gt; Sincerely,
gt; Leith Ross
gt;
gt;
gt; --
gt; Leith Ross
gt; ------------------------------------------------------------------------
gt; Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
gt; View this thread: www.excelforum.com/showthread...hreadid=503418
gt;
gt;