Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide .00's in a worksheet & keep the ones that say 10.7
Format the cells as General (FormatCellsNumber tab'General') will show
decimal places only when needed If this post helps click Yes --------------- Jacob Skaria "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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide .00's in a worksheet & keep the ones that say 10.7
Format the cells to General.
Assuming the 10.00 is the actual value of the cell. If 10.00001 then this will not work. Gord Dibben MS Excel MVP On Sun, 29 Nov 2009 08:25:01 -0800, 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to hide a row in different worksheet | Excel Discussion (Misc queries) | |||
how to hide a worksheet | Excel Discussion (Misc queries) | |||
how to hide worksheet using VB | Excel Worksheet Functions | |||
hide worksheet | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |