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
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
Based on the cell values in cells b77 - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

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

If a cell contains any text then add a value

Fill adjacent cell with number from text answer

If cell = date return yes or no.

Condition formatting on changing cell color based on another cel

Similar discussions

Subscribe To Our Newsletter!