A Workbook I've been resaving as different versions recently changed
it's column references to numbers instead of letters. So, B=2, AA=27,
etc. Also, when I build forumlas the reference for a cell is it's row
x cell, each of which as position X & Y coordinates. There are some
copy/paste issue with formulas, which may or may not be related.

Tools / Options... General tab, UNcheck "R1C1 reference style"

HTH,
Bernie
MS Excel MVP


<(E-Mail Removed)> wrote in message
news:322a2cd6-0bf7-4e88-848d-(E-Mail Removed)...
>A Workbook I've been resaving as different versions recently changed
> it's column references to numbers instead of letters. So, B=2, AA=27,
> etc. Also, when I build forumlas the reference for a cell is it's row
> x cell, each of which as position X & Y coordinates. There are some
> copy/paste issue with formulas, which may or may not be related.

In xl2007, it's somewhere under the Office button|Excel Options.



Bernie Deitrick wrote:
>
> Tools / Options... General tab, UNcheck "R1C1 reference style"
>
> HTH,
> Bernie
> MS Excel MVP
>
> <(E-Mail Removed)> wrote in message
> news:322a2cd6-0bf7-4e88-848d-(E-Mail Removed)...
> >A Workbook I've been resaving as different versions recently changed
> > it's column references to numbers instead of letters. So, B=2, AA=27,
> > etc. Also, when I build forumlas the reference for a cell is it's row
> > x cell, each of which as position X & Y coordinates. There are some
> > copy/paste issue with formulas, which may or may not be related.

--

Dave Peterson