Previous Topic Next Topic

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.

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
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Comparing columns and returning value
ll -
kittu -

35 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses