Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

the numbers are always in text and i cant seem to change them???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
neil - 20 Dec 2005 22:10 GMT
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
Ron Rosenfeld - 20 Dec 2005 22:25 GMT
>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

You need to format the cells as Number or General BEFORE you enter the numbers.

--ron
Gord Dibben - 20 Dec 2005 23:19 GMT
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 Special>Add>OK>Esc.

Data should now be numbers.

Gord Dibben Excel MVP

>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
neil - 20 Dec 2005 23:57 GMT
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?????

> Neil
>
[quoted text clipped - 18 lines]
> >does not work, i have even re-installed office with no luck, can any body
> >help me
Dave Peterson - 21 Dec 2005 00:24 GMT
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.

> Gord,
>
[quoted text clipped - 24 lines]
> > >does not work, i have even re-installed office with no luck, can any body
> > >help me

Signature

Dave Peterson

neil - 21 Dec 2005 01:49 GMT
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??

> If you close excel and restart it in Safe mode, does it still occur?
>
[quoted text clipped - 46 lines]
> > > >does not work, i have even re-installed office with no luck, can any body
> > > >help me
Gord Dibben - 21 Dec 2005 20:41 GMT
Neil

May not do any good but can't harm if you send me by email a book with the
problem.

Change the DOT and AT to . and @ in my email address.

Gord

>Dave & Gord,
>
[quoted text clipped - 52 lines]
>> > > >does not work, i have even re-installed office with no luck, can any body
>> > > >help me
Gord Dibben - 21 Dec 2005 01:13 GMT
Neil

My next shot would have been basically what Dave P. has suggested.

I think the workbook/worksheet template you're using is formatted as text and
you should start over with the default File>New...>Blank Workbook that Excel
provides.

This default workbook is not based on the one you have in your XLSTART folder.

I am surprised however, that the "copy a blank cell formatted to General" does
not fix the formatting of the cells.

Gord

>Gord,
>
[quoted text clipped - 24 lines]
>> >does not work, i have even re-installed office with no luck, can any body
>> >help me
neil - 20 Dec 2005 23:53 GMT
I have tried both answere's and none has worked for me, the problem occurs on
all worksheets wether they are new or old.

> 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
eyane - 21 Dec 2005 02:50 GMT
I get this problem a lot when i import from another data source. Add a column
and multiply the original cell by 1. For ex, in cell B1 Type =A1*1

> 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
neil - 21 Dec 2005 03:34 GMT
eyane,

I just tried that one and it brought up a formulae error.

Neil.

> I get this problem a lot when i import from another data source. Add a column
> and multiply the original cell by 1. For ex, in cell B1 Type =A1*1
[quoted text clipped - 3 lines]
> > does not work, i have even re-installed office with no luck, can any body
> > help me
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.