Want cells to show e.g. £100.00 when there is a value
Closed
Hello,
I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing, no £ symbol because at the moment I have numerous cells showing only a £ symbol with no value next to it. How do I do this? Thanks in advance.
I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing, no £ symbol because at the moment I have numerous cells showing only a £ symbol with no value next to it. How do I do this? Thanks in advance.
Related:
- Want cells to show e.g. £100.00 when there is a value
- Excel macro to create new sheet based on value in cells - Guide
- Based on the cell values in cells b77 - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum