Excel 2007: Digits turned into decimals automatically

Tags:
Excel 2007
Microsoft Excel
In Microsoft Excel, last 2 digits are turned to decimal automatically. What should I do?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You need to check the formatting of the cell(s). Depending on what version of Excel, right-click on the cell or the column. Select FORMAT CELLS. Then under the NUMBER tab, you select number and set the number of decimals you want the cells to have. Then click the OK button. 

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Assuming this is Excel 2007, as the tag indicated, in Excel 2007, click office button, then click excel options, now select advanced in the left hand & here you can uncheck automatically insert a decimal point. Next click OK. Hope it helps you.
    137,090 pointsBadges:
    report
  • jinteik
    Or you can actually just put it as a general column.
    18,995 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: