column numbers

S

southernliving

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
 
P

Peo Sjoblom

Tools>options>general and uncheck R1_C1 reference style, nothing to do with
Mac though, just the way Excel was setup

Regards,

Peo Sjoblom
 
Top