Automating text in a cell
 

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

Automating text in a cell
 

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 FormatCellsNumber and select Custom in the left panel
3) in the Type box on the right enter this - including the quotation marks

"JW/R"#

4) Click on OK

Now when somebody types a number in those cells it will display with the
JW/R prefix


"Jock W" wrote:

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

Automating text in a cell
 

That's sorted it. Many thanks,
--
Jock Waddington


"Duke Carey" wrote:

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 FormatCellsNumber and select Custom in the left panel
3) in the Type box on the right enter this - including the quotation marks

"JW/R"#

4) Click on OK

Now when somebody types a number in those cells it will display with the
JW/R prefix


"Jock W" wrote:

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