Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete numbers in a cell
I have two rows, one with numbers A, and one empty B. I put "x" in B, when I
need to show that the payments in A has been done. How do I make the numbers dissapear? I have formatted A so that the numbers in A gets white when I write "x" in B so the numbers don't show. But the numbers are still there(althoug hidden), and the sum in the bottom don't change. Is there a formel I can use? Great if you know! -- Therese |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
How can I add different numbers in a same cell? | Excel Discussion (Misc queries) | |||
how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |