Default zero number in a cell

[Yaghoub61]

Hello,

I want a zero number in the cell A1
When a data was entered in the cell A1
I deleted it later
The zero number is entered in the cell by default.

Thank you in advance

 

[Special-K99]

Unclear.

Cells can contain a value or a formula, not both.

If you enter 0 in A1 it will overwrite any previous formula the cell held.
If you want it to work this way you need to use VBA, of which I;m not an expert.'

Provide some examples to clarify what you are after.

 

[Misca]

This piece of code chenges the value of set range to 0:

Range("A1:C25").Value = 0

I'm sure you know / will figure our how to adjust the range of cells to match your needs.

 

[Yaghoub61]

Thanks for Reply