Customize Decimals in MS Excel

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by annadaya
Best Answer
Best Answer
Answered By 0 points N/A #118039

Customize Decimals in MS Excel

qa-featured

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.

Answered By 0 points N/A #118040

Customize Decimals in MS Excel

qa-featured

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 🙂

Login/Register to Answer

Related Questions