Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them???
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them???
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 You need to format the cells as Number or General BEFORE you enter the numbers. --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them???
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
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 On Tue, 20 Dec 2005 17:49:02 -0800, "neil" wrote: 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
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 FileNew...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 On Tue, 20 Dec 2005 15:57:02 -0800, "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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them???
I have tried both answere's and none has worked for me, the problem occurs on
all worksheets wether they are new or old. "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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them???
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 "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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the numbers are always in text and i cant seem to change them?
eyane,
I just tried that one and it brought up a formulae error. Neil. "eyane" wrote: 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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) |