How do I restore column & row cell references

[emitch511]

When I open a workbook, my column headers display as numbers rather than the
alpha characters. When I build formulas, the cell reference is for example
RC(-1). How can a restore the colums in my workbook to display as A, B, C...
and cells to show as A2, etc?

[Roger Govier]

Hi
Tools>Options>General>uncheck the R1C1 option.

--
Regards

Roger Govier


"emitch511" <emitch511@discussions.microsoft.com> wrote in message
news:415A1FB4-AADD-45D6-A911-FE5B3C49DAAC@microsoft.com...
> When I open a workbook, my column headers display as numbers rather
> than the
> alpha characters. When I build formulas, the cell reference is for
> example
> RC(-1). How can a restore the colums in my workbook to display as A,
> B, C...
> and cells to show as A2, etc?