assign blank to E1 cell value (C1 Lis t= E1) without using formula because it returns zero

The goal of this project is simple: Make the cell E1 (cell in red) default to an empty cell if the cell it is referring to(C1), the cell in green does not have any selection.

The following do NOT ok:
1. Setting the defaults in excel to not show cells with 0 values.
2. Do not suggest that we use a marco. I want a simple solution.
3. Do you use IF( D2 = 0, "", D2), we don't want any formulae.

Here is how you know you did it right. Save the file and open it with notepad, if you don't see a 0, you got it right and we will pay you right away.

a better test would be: Save the file as a .csv and check the 6th column (in notepad) and it should be empty.

Thank you

Here is the attachment file,
I hope I can get a quick reply.

Thank you.

FYI the user also opened a thread here with the same question and there already seems to be an answer involving changing the cell format.
http://www.mrexcel.com/forum/excel-q...ml#post3381093

Right click cell E1, select Format Cells, in the number tab select Custom and then in the Type: put 0;-0;;@

Thank you for your help RHCPgergo.

Have a great day.

Haha not to me! :D

That is nice indeed. :P

Originally Posted by Moo the Dog

@RHCPgergo:
In the immortal words of Carl Spackler...
- Moo

OH! Sure, turn on the lights just when I have to leave the room... Carl, just hook me up with Lacey and we'll call it even!