| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
