replace zero for minus values by cell format if it's possible

[Abdo]

Hi

I no know if it's possible do that without macro . is it possible by cell format

so I have minus values in column E I want showing zero . the column E could be numbers or formula . if it's not possible, no problem by vba

but I want showing zero in column E when write numbers in column C or column D directly not every time I have to press button the macro to show zero .
thanks

 

[Abdo]

@Peter_SSs thanks for your advices and correcting some errors in the orginal code .
of course the second code is much better than separate 'test' procedure.
much appreciated for your help

 

[Peter_SSs]

You're welcome.