Dear Gord,
thanks for your reply but the whole spreadsheet has this problem, so I can't
find an empty cell to set as General then copy. Even when I open up a new new
workbook, it still opens like this. Do You have anymore suggestions. Thanks.

Louis

"Gord Dibben" wrote:

Louis

If the numbers are formatted as Text, simply re-formatting to number will not
do the trick.

Try this usual fix.

Format the cells as General then copy an empty cell.

Select the range of text numbers and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 12:49:02 -0800, "quale"
wrote:

Dear Colleague,
When the cell is formatted for text and I change to number, it only returns
the number with two decimal places It will not change to a whole number or
number with decimals.

I tried re-loading the application and that did not work? I have Excel 2000
and sent the file to a 2002 user and it loaded fine.

I have seen in other applications from users that for some reason their
numbers have quotations marks around them and they can't do formulas. Please
help.

Thanks.

Louis