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?
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) |