software

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 quot;JW/Rquot; would appear and the user could
enter quot;554quot; for example

tia
--
Jock Waddington

One way is to format the cell so that it DISPLAYS the prefix. The cell's
VALUE would not include the JW/R, but it would display and print with the
prefix. If that is satisfactory for your purposes:
1) select the cell or range of cells,
2) go to Formatgt;Cellsgt;Number and select Custom in the left panel
3) in the Type box on the right enter this - including the quotation marks

quot;JW/Rquot;#

4) Click on OK

Now when somebody types a number in those cells it will display with the
JW/R prefixquot;Jock Wquot; wrote:

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

That's sorted it. Many thanks,
--
Jock Waddingtonquot;Duke Careyquot; wrote:

gt; One way is to format the cell so that it DISPLAYS the prefix. The cell's
gt; VALUE would not include the JW/R, but it would display and print with the
gt; prefix. If that is satisfactory for your purposes:
gt; 1) select the cell or range of cells,
gt; 2) go to Formatgt;Cellsgt;Number and select Custom in the left panel
gt; 3) in the Type box on the right enter this - including the quotation marks
gt;
gt; quot;JW/Rquot;#
gt;
gt; 4) Click on OK
gt;
gt; Now when somebody types a number in those cells it will display with the
gt; JW/R prefix
gt;
gt;
gt; quot;Jock Wquot; wrote:
gt;
gt; gt; Is it possible to apply a formula to a cell so that as soon as it is clicked
gt; gt; into, a prefix for an order number wil appear, leaving the user to input the
gt; gt; actual digits of the order no after the text?
gt; gt; IE. upon clicking the cell, the text quot;JW/Rquot; would appear and the user could
gt; gt; enter quot;554quot; for example
gt; gt;
gt; gt; tia
gt; gt; --
gt; gt; Jock Waddington