• Please be sure to read the rules and adhere to them. Some banned members have complained that they are not spammers. But they spammed us. Some even tried to redirect our members to other forums. Duh. Be smart. Read the rules and adhere to them and we will all get along just fine. Cheers. :beer: Link to the rules: https://www.forumsforums.com/threads/forum-rules-info.2974/

MS Excel question

B

bczoom

Super Moderator
Staff member
GOLD Site Supporter
Don't know what I did but when I open a spreadsheet in Excel now, all the columns are now numbers instead of letters.

How can I change it back to letters?

Formulas got more complicated.
What used to be
=SUM(C3:C97)
is now
=SUM(R[-97]C:R[-29]C)

PS. This is Excel 2010
 
squerly

squerly

Supported Ben Carson
GOLD Site Supporter
File-> Options-> Formulas->
and then (un)click the first option under "working with formulas".
 
You must log in or register to reply here.
Top