Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have tried & can't get rid of the decimal point in an Excel
I have used all format options and cannot put in numbers without them
defaulting to 2 decimal places. I put in 22 and when I move to another cell it defaults to .22. If I format the cells to 0 decimal places, it zeros out the numbers. I have tried verything including re-installation and error check. Has anyone else had this problem? The only way to get numbers in is with text and then functions do not work. Others send me spreadsheets with numbers but I cannot change the numbers without the problem happening This is Office 2003 Prof |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have tried & can't get rid of the decimal point in an Excel
Try this:
From the Excel main menu: <tools<options<edit tab UNcheck: Fixed decimal places Does that help? *********** Regards, Ron XL2002, WinXP "WJP" wrote: I have used all format options and cannot put in numbers without them defaulting to 2 decimal places. I put in 22 and when I move to another cell it defaults to .22. If I format the cells to 0 decimal places, it zeros out the numbers. I have tried verything including re-installation and error check. Has anyone else had this problem? The only way to get numbers in is with text and then functions do not work. Others send me spreadsheets with numbers but I cannot change the numbers without the problem happening This is Office 2003 Prof |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions |