Is it possible to apply a formula to a cell so that as soon as it is clicked
into, a prefix for an order number wil appear, leaving the user to input the
actual digits of the order no after the text?
IE. upon clicking the cell, the text "JW/R" would appear and the user could
enter "554" for example

tia
--
Jock Waddington