Default Value

[rparedes]

Hi,

I would like to know if this is possible without doing coding. Here's what I want to achieve, I want to have a cell to have a default value

i.e. cell B1 to have a default value of "Php0.00" user can type the currency amount on B1 but if the user deleted the entered value it will default back to "Php0.00"

Thanks,

 

[Fluff]

Hi & welcome to MrExcel
That would need VBA.