I have seen in some excel sheets, when I delete the input, there is a
watermark or meaning the original text is restated. By way of example:

1. Initial display in cell A1: -Please Input Value-
2. And when a value is entered (say) 1000 + enter = 1,000
3. When the value in 2 above is deleted, the original/initial text -Please
Input Value is- is displayed.

How is this done?

Thank you.