my columns have changed to show numbers and formula are different
 

Working in excel i have found my colum values have changed from letters to
numbers and the formula i am calculating have changed

my columns have changed to show numbers and formula are different
 

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" wrote:

Working in excel i have found my colum values have changed from letters to
numbers and the formula i am calculating have changed

my columns have changed to show numbers and formula are different
 

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



"Ian" wrote:

Working in excel i have found my colum values have changed from letters to
numbers and the formula i am calculating have changed

my columns have changed to show numbers and formula are differ
 

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



"Francis" wrote:

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



"Ian" wrote:

Working in excel i have found my colum values have changed from letters to
numbers and the formula i am calculating have changed