View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

"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