Want cells to show e.g. £100.00 when there is a value

Closed

Jordan - Jan 12, 2015 at 05:30 AM
RayH - Jan 12, 2015 at 11:29 AM

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.

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
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
Which key is used to make multiple line in a single cell - Guide

1 response

Answer 1 / 1

RayH
Jan 12, 2015 at 11:29 AM

What formatting do you have applied to the cell(s)?

Similar discussions

help me to add particular cells

Condition formatting on changing cell color based on another cel

If cell = date return yes or no.

Excel - IF function with multiple words

Compare values in two columns and return the value from third

Similar discussions

Subscribe To Our Newsletter!