How to display zero values?

T

tandem

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zero(0) values box checked-but not displayed as a 1st digit ? 3
Show zero values in specific area 4
formula result is zero but zero is not populating in cell 3
First row where a cell is zero 1
A list which don not include zero 5
Min excluding zero values, without an array fomrula 13
Zero Values 2
Hide zero values 2

Top