Quick Excel Question!

[zendle]

How do i remove all the unnecessary $0.00 when there is no value. I have entered a formula and dragged it down (like i usually do past all the current information) but it displays $0.00 instead of nothing until the line is filled.

http://speedcap.net/sharing/screen.p...a5c5118c55.png

[GC Excel]

Hello zendle,

Difficult to give proper answer with a picture...!

Did you look at the number format?
or are you in Manual calculation mode? (what happens if you press F9)?

What's your formula?

[FDibbins]

zendle, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[zendle]

Hello zendle,

Difficult to give proper answer with a picture...!

Did you look at the number format?
or are you in Manual calculation mode? (what happens if you press F9)?

What's your formula?

=C3*IF(G3="eBay",0.08,IF(G3="Website",0.02,IF(G3="Other",0)))

I drag it down from the top buy instead of the $0.00 being hidden until the field is filled, it displays $0.00 all the way down.

[alansidman]

@zendle
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.