View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default How do you hide .00's in a worksheet & keep the ones that say 10.7

Format the cells as General. Select the cells (or all cells if desired), then
right-click. Select Format Cells on the Number tab select General OK.

Alternatively, you could experiment with a Custom format like #,##0.##

Hope this helps,

Hutch

"Reynolds" wrote:

I want to be able to have all my .00's in worksheet as not showing the
decimal places, and want to keep all the ones that have decimal places as .75
etc.

In other words, I don't want to "hide" the 2 decimal places that actually
have cents on there (for example, keep all the 10.75's, 10.68's, but hide all
the zeros in 10.00 so that tht zero cents just show as 10 instead of
10.00....)?

I don't want to have to go and select all the individual cells that show
with zeros and change them to showing zero decimals...