Customize Decimals in MS Excel

Asked By carlton mitchell 0 points N/A Posted on - 12/03/2011

I used Excel for computing daily expenses and profits. Lately, I’ve been encountering problems and since I only knew some basic functions in Excel, I could not resolve it by myself.

My problem is, I don’t know where and how to customize the decimals that I put on each cell.

When I insert 198 on cell A1 and hit enter, the output will become 1.98.

How can I fix this?

• Status: Open
• Question Views: 948
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by annadaya

Go To Solution

Best Answer

Best Answer

Answered By annadaya 0 points N/A #118039

Customize Decimals in MS Excel

Hello,

Maybe the Format of your cell is different from what you expect it to be.

Right Click the Cell or group of cell that you wanted to set it's format.

Click Format Cells then choose Number then you can choose any format you want on the Category, in your case just choose General or maybe the Custom and choose the two decimal place (0.00).

Hope that answers your question.

About annadaya

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/03/2011
• Question Category: MS Excel

Answered By annadaya 0 points N/A #118040

Customize Decimals in MS Excel

Hello there!

Don't worry about that the more you encounter problem about MS Excel the more you will learn. The reason why the output of your cell is different it's because the format is different from what you expect it to be.

To change that please Right Click the Cell or Group of cell that you wanted to set it's format, after that Click Format Cells then Choose Number then you can choose any format you want on the Category Section, in your case just Choose General or maybe the Custom and choose the two decimal places (0.00) to be more specific.

Explore more about MS Excel, it's fun and at the same time it's knowledgeable, MS Excel is very useful and effective so be more resourceful about it.

Hope that answers your question 🙂

About annadaya

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/05/2011
• Question Category: MS Excel