| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make the 0 hidden with erasing the formula in a block?
Please help asap. I have a project due and I dont want all those zeros on
the page but I dont want to erase all my formulas. I need them there for when I plug in my numbers. -- tm |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make the 0 hidden with erasing the formula in a block?
Try the following custom format:
1. Select Format | Cells |Custom 2. Enter -- LPS "floydgrading" wrote: Please help asap. I have a project due and I dont want all those zeros on the page but I dont want to erase all my formulas. I need them there for when I plug in my numbers. -- tm |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make the 0 hidden with erasing the formula in a block
How about the simple expediant of going to Tools/Option/View and deselecting
"Zero values". Roger "LPS" wrote: Try the following custom format: 1. Go to Format | Cells | Number | Custom 2. In the "Type" field, enter: $#,##0.00;-0;;@ You can also omit the dollar sign at the start if you want. Hope this helps -- LPS "floydgrading" wrote: Please help asap. I have a project due and I dont want all those zeros on the page but I dont want to erase all my formulas. I need them there for when I plug in my numbers. -- tm |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make the 0 hidden with erasing the formula in a block
The drawback with that is that it affects the whole sheet as opposed to
custom formatting -- Regards, Peo Sjoblom "RogerN" wrote in message ... How about the simple expediant of going to Tools/Option/View and deselecting "Zero values". Roger "LPS" wrote: Try the following custom format: 1. Go to Format | Cells | Number | Custom 2. In the "Type" field, enter: $#,##0.00;-0;;@ You can also omit the dollar sign at the start if you want. Hope this helps -- LPS "floydgrading" wrote: Please help asap. I have a project due and I dont want all those zeros on the page but I dont want to erase all my formulas. I need them there for when I plug in my numbers. -- tm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| one formula to make a multiplication table work | Excel Worksheet Functions | |||
| Make a formula that adds every 4th cell in a column indefinately? | Excel Worksheet Functions | |||
| How to make excel not to compute formula | Excel Worksheet Functions | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Linear Mode
