Hi,

It changes on its own because Excel remembers the setting from the first
workbook opened in that session. Change between settings won't affect the
result of calculations, only the way you see the formula.

Mike

"Gerrie" wrote:

aI see the posts concerning how to change column heading to numbers, etc.
However, I would like to know how this happens because, if I open a new
spreadsheet, sometimes I get numbers and sometimes I get letters. Also, when
someone sends me a spreadsheet with numbers and I want letters and they have
calculations, can I can to letters and will the calculations change
automatically or how will they be affected. HELP!
--
Thanks for any help you can give me.