How would I display a value in a cell without entering formula in.

[Frank Kabel]

Hi
you may post your question as body of your message

 

[Gord Dibben]

If you don't type it in, you would use VBA code to place it there.

Gord Dibben Excel MVP