I Ian Mar 30, 2009 #1 Working in excel i have found my colum values have changed from letters to numbers and the formula i am calculating have changed
Working in excel i have found my colum values have changed from letters to numbers and the formula i am calculating have changed
M Mike H Mar 30, 2009 #2 Ian, It's because the first workbook you opened in the session was set to R1C1. Tools|Options - General tab and un-check R1C1. Mike
Ian, It's because the first workbook you opened in the session was set to R1C1. Tools|Options - General tab and un-check R1C1. Mike
F Francis Mar 30, 2009 #3 try Tools >> Options >> General >> uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
try Tools >> Options >> General >> uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
F Francis Mar 30, 2009 #4 Oops, should read Tools >> Options >> General >> check R1C1 reference style because your R1C1 have been unchecked. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
Oops, should read Tools >> Options >> General >> check R1C1 reference style because your R1C1 have been unchecked. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
