LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do you hide .00's in a worksheet & keep the ones that say 10.7

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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to hide a row in different worksheet TDC Excel Discussion (Misc queries) 3 April 24th 23 09:04 PM
how to hide a worksheet deepika :excel help[_2_] Excel Discussion (Misc queries) 2 February 4th 08 01:38 PM
how to hide worksheet using VB associates Excel Worksheet Functions 1 June 15th 06 08:01 AM
hide worksheet Ankur Excel Discussion (Misc queries) 2 August 11th 05 11:52 AM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"