Prev: I want to compare two coloumn particular text, then count total
Next: copy paste value
From: John on 22 Apr 2010 08:40
Thank you very much for posting this! I am still not sure how I flipped it,
as I know I was not in that screen before, but at least it is fixed now!


"T. Valko" wrote:

> In Excel 2007:
>
> Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
> reference style>OK
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "tstrong5" <tstrong5(a)discussions.microsoft.com> wrote in message
> news:020C3AC6-DAC8-4714-A334-37733AF753C8(a)microsoft.com...
> >I am having the same problem. Did you find an answer?
> >
> > "Pella Engineer" wrote:
> >
> >> There is no Tool/Option on the toolbar in Office 2007. How do I get the
> >> coumn
> >> headers converted from numbers to letters in this case?
> >>
> >> "plumeria54" wrote:
> >>
> >> > Thank you - that was too easy...!
> >> >
> >> > "Rick Rothstein (MVP - VB)" wrote:
> >> >
> >> > > Click Tools/Options on Excel's menu bar, select the General tab on
> >> > > the
> >> > > dialog box that appears and uncheck the box next to the label "R1C1
> >> > > reference style" in the Settings section.
> >> > >
> >> > > Rick
> >> > >
> >> > > "plumeria54" <plumeria54(a)discussions.microsoft.com> wrote in message
> >> > > news:DE3CE0EC-1393-4905-8309-83368A2D0F79(a)microsoft.com...
> >> > > > My spreadsheets suddenly show numbers for the columns instead of
> >> > > > letters --
> >> > > > columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas
> >> > > > in
> >> > > > cells
> >> > > > now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5
> >> > > > How do I change the columns back to letters?
> >> > >
> >> > >
>
>
>
 | 
Pages: 1
Prev: I want to compare two coloumn particular text, then count total
Next: copy paste value