Blank Cells....

  • Thread starter Thread starter Freddie
  • Start date Start date
F

Freddie

I am using Excel 2007 on Win XP Pro SP2,
How is it possible to do the following please?
I have several columns formatted to currency. When the amounts in them are
nil, they show up as follows: £0.00, I would rather they showed as an empty
cell, is this possible? If so how do I accomplish this?
I am only a novice with Excel, so please try to keep answers simple.
Many Thanks for any replies.
 
Office button (top left)>Excel Options>Advanced tab>Display options for this workbook>Uncheck Show a zero in cells that have zero
value

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using Excel 2007 on Win XP Pro SP2,
| How is it possible to do the following please?
| I have several columns formatted to currency. When the amounts in them are
| nil, they show up as follows: £0.00, I would rather they showed as an empty
| cell, is this possible? If so how do I accomplish this?
| I am only a novice with Excel, so please try to keep answers simple.
| Many Thanks for any replies.
|
|
 
Sat said:
I am using Excel 2007 on Win XP Pro SP2,
How is it possible to do the following please?
I have several columns formatted to currency. When the amounts in them are
nil, they show up as follows: £0.00, I would rather they showed as an empty
cell, is this possible? If so how do I accomplish this?
I am only a novice with Excel, so please try to keep answers simple.
Click to expand...

Press F1 to bring up help.

In the search box, type "display or hide zero values" (no quotes).

(I have Excel 2003, and I'm not sure of the equivalent command in
2007, but the help text will tell you.)
 
Freddie said:
I am using Excel 2007 on Win XP Pro SP2,
How is it possible to do the following please?
I have several columns formatted to currency. When the amounts in them are
nil, they show up as follows: £0.00, I would rather they showed as an
empty cell, is this possible? If so how do I accomplish this?
I am only a novice with Excel, so please try to keep answers simple.
Many Thanks for any replies.
Click to expand...
Thanks, Niek & Stan, problem sorted now with your help.
 
Back
Top