On Thu, 2 Dec 2004 17:21:02 -0800, "burkeville"
wrote:

Ron, Thanks for coming to my aid. All of the cells in this spreadsheet have
been formated since I created the sheet in '96. Originally it was excel 97,
and through the years has been upgraded to 2002. This was done early 03. For
about the last 3 months though these same cells that were formatted in
numbers are now storing new numbers as text. Microsoft has a method I have
been using to change the format in ranges and I have also use the error
control to change individual cells. Thanks for any ideas. Bobby
"Ron Rosenfeld" wrote:

Have you saved the workbook in the same format as the present Excel release, or
are you keeping it in the XL97 (or older) format?

When you enter a number into one of these cells, do you type it in from the
keyboard, or are you using a different method.

What is the format of the cell before you enter a new number that might get
changed to text?


--ron