Blank Cells....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freddie - 15 Dec 2007 19:50 GMT

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.

Reply to this Message

Niek Otten - 15 Dec 2007 20:04 GMT

Office button (top left)>Excel Options>Advanced tab>Display options for this workbook>Uncheck Show a zero in cells that have zero
value

Signature

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?
[quoted text clipped - 3 lines]
| I am only a novice with Excel, so please try to keep answers simple.
| Many Thanks for any replies.

Reply to this Message

Stan Brown - 15 Dec 2007 20:19 GMT

Sat, 15 Dec 2007 19:50:36 GMT from Freddie <freddie@ntlword.com>:

> 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.

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.)

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message

Freddie - 15 Dec 2007 23:50 GMT

>I am using Excel 2007 on Win XP Pro SP2,
> How is it possible to do the following please?
[quoted text clipped - 3 lines]
> I am only a novice with Excel, so please try to keep answers simple.
> Many Thanks for any replies.

Thanks, Niek & Stan, problem sorted now with your help.

Reply to this Message

Rate this thread: