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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Find rows that contain capital letter? 4
Booklet in Word, Merge Directory from Excel 0
Columns now numbers rather than letters how do i get letters back 2
Need Help with a VBA subroutine 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
VLOOKUP isn't working properly in Excel on Mac 1

Top