column numbers
 

how do you change the column identification fromnumber back to letters. I
imported a spreadsheet from a Mac Excel applicatioon and it came in with the
columns identified by number rather than letters. Make formula
troubleshooting confusing

Thanks

Toolsoptionsgeneral and uncheck R1_C1 reference style, nothing to do with
Mac though, just the way Excel was setup

Regards,

Peo Sjoblom

"southernliving" wrote:

how do you change the column identification fromnumber back to letters. I
imported a spreadsheet from a Mac Excel applicatioon and it came in with the
columns identified by number rather than letters. Make formula
troubleshooting confusing

Thanks

Hi
goto 'Tools - Options - General' and uncheck 'R1C1 Reference style

--
Regards
Frank Kabel
Frankfurt, Germany

southernliving wrote:
how do you change the column identification fromnumber back to
letters. I imported a spreadsheet from a Mac Excel applicatioon and
it came in with the columns identified by number rather than letters.
Make formula troubleshooting confusing

Thanks