View Single Post
  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Wed, 1 Dec 2004 11:09:04 -0800, "burkeville"
wrote:

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


Select the cells where you are entering these numbers and, before you enter any
data, format the cells as General or as Number.


--ron