ExcelBanter - How to display zero values?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to display zero values? (https://www.excelbanter.com/excel-worksheet-functions/7234-how-display-zero-values.html)

tandem

How to display zero values?

How to display zero values in spreadsheet? Currently I type '12.00' but
worksheet display '12'. I have checked Tools Options View tab,

but 'Zero values' check box was ALREADY CHECKED.

Thanks

breeze

JE McGimpsey

"Zero values" refers to a value of 0, not the number of decimal places.
Format your cell as a Number (Format/Cells/Number/Number) and enter 2 in
the number of decimal places box.

In article ,
"tandem" wrote:

How to display zero values in spreadsheet? Currently I type '12.00' but
worksheet display '12'. I have checked Tools Options View tab,

but 'Zero values' check box was ALREADY CHECKED.

Thanks

breeze

All times are GMT +1. The time now is 07:23 AM.