Discussion Locked

Excel Decimal Points

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an excel 97 document and I am clicking the increase and decrease decimal buttons but the decimals don't increase after I have formatted to currency or comma style. When I click the increase decimal button the column width increases. When I click the decrease decimal button the dollar sign moves back to the left, away from the numbers. It does not add additional zeros or numbers as it should. I closed out of Excel and went back into it with a blank document. In an empty cell I typed in 100 and formatted it to currency style and it worked. Then I typed 200 into the next cell and 300 into the following cell and then selected all three and then set them all to currency style and then clicked on the increase/decrease decimal buttonsand the same happened as before. It just increased the column width. Then I went into another blank cell and typed in another number (100) and formatted it again and then clicked on the increase/decrease decimal buttons and the same thing happenedagain. I don't know what is happening. It has only worked for me that one time, the rest of the time it just increases the column width. Please help, I have training on these machines Monday. :) Thanks!

3 replies

by firefox

To me, it sounds like you have the cells formatted as Text instead of Number or Currency. See the Microsoft article ID #Q141765 at http://search.support.microsoft.com for details, or go directly to http://support.microsoft.com/support/kb/articles/Q141/7/65.asp?LN=EN-US&SD=gn&FR=0&qry=cell%20formatting&rnk=38&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

A couple of workarounds they mention is are:
Method 1: Retype the Numbers
After you change the format, retype the numbers.

Method 2: Select Edit Directly In Cell
On the Tools menu, click Options or Preferences, click the Edit tab, and verify
that the Edit Directly In Cell check box is selected. Double-click the cell you want to format, and press ENTER.

There are more methods listed, but they are too lengthy to post here.

I hope this helps. Good luck on Monday! :-)

This discussion is closed to new replies.