I have tried & can't get rid of the decimal point in an Excel

W

WJP

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
 
R

Ron Coderre

Try this:

From the Excel main menu:
<tools><options><edit tab>
UNcheck: Fixed decimal places


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Fraction to Decimal 2
Convert number to text as displayed 4
Decimal point in general format 1
Addition errors with Decimal Places 6
decimal point in general number 2
excel 2003 zero as last decimal 5
problem with number format with 2 decimals? 5

Top