Adding default values to cells

[willhaywood]

Hi All,

I am having some difficulty adding a default value to a cell.

What I want to do is have a cell that will read "Enter value here" if nothing has been added, but display the users text when changed.

I've been playing with the IF statement feature for a while, but am getting nowhere.

Any ideas?

Thanks

Will

 

[willhaywood]

Got it!

Thanks very much to both of you!

Will

 

[jproffer]

All thanks and credit are owed to Schwarzmanne.