Dave & Gord,

I have started excel up in safe mode with still the same problem, i also had
a look at the XLSTART folder there were no documents in there. Any thing else
i can try??

"Dave Peterson" wrote:

If you close excel and restart it in Safe mode, does it still occur?

Close excel
windows start button|Run
excel /safe

Start typing in that new workbook--not a file that you open.

I'm guessing that you have a book.xlt template workbook in your XLStart folder
that has all the cells formatted as text.




If it works ok when you start in safe mode, then close excel and try this:

Use windows explorer and search for XLStart.
Move all the book.xlt (along with sheet.xlt) to a different (out of the way)
location.

Then try opening excel normally. Start a new workbook to test it out.

If that works, you'll still have to fix any existing workbook--just format the
cells you want to change as General.


neil wrote:

Gord,

This occurs with every workbook? New workbooks? Existing workbooks? i have
tried your suggestion with no luck, i have even re installed excel, any more
suggestions?????

"Gord Dibben" wrote:

Neil

Does this occur with every workbook? New workbooks? Existing workbooks? Just
one workbook?

First make sure the cells are formatted as General and not Text.

A Format change alone after the fact will not change the data to numbers.
Excel must be forced to recognize the data as numbers.

To change existing data to numbers, copy an empty cell.

Select range of data and Paste SpecialAddOKEsc.

Data should now be numbers.


Gord Dibben Excel MVP


On Tue, 20 Dec 2005 14:10:02 -0800, "neil"
wrote:

When ever i start excel 2003 and type numbers they come up as text so i can
not use any functions, i have tried formatting the cells to numbers but this
does not work, i have even re-installed office with no luck, can any body
help me


--

Dave Peterson