Maybe you could pre-format the cells?

--
Don Guillett
SalesAid Software

"burkeville" wrote in message
...
I have a large Excel spreadsheet that I have used for years. It is Excel
2002
now with SP3. For a while now my calcs are off because the numbers I enter
in
cells are being stored as text. I understand how to change them to
numbers,
but when I add new numbers, those store as text also. Constantly having to
convert text to numbers. Thanks for any help I can get. Bobby