ExcelBanter - Zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Zeros (https://www.excelbanter.com/excel-discussion-misc-queries/90384-zeros.html)

karen

Zeros

I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click
enter, it changes to 24.95. How can I get it to leave the zero (0) in?

Toppers

Zeros

Format cell as number with 3 decimal places

"karen" wrote:

I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click
enter, it changes to 24.95. How can I get it to leave the zero (0) in?

[email protected]

Zeros

Go to Format menu / cells / number / number / Decimal places change to
3.

ed

All times are GMT +1. The time now is 12:31 AM.