Automating entry in a cell
I am trying to automate entry in a cell, in which the first digit will
always be the same value, such as "X", followed by a 6 digit number to
be entered. What I envision is that each cell in this column will have
the "X" value hardcoded in the first position so that entry of the 6
digit number can begin at the second position when the user selects the
cell. Another possibility would be for the user to enter the 6 digit
number and the "X" populate the cell in the first position when the
user exits the cell.
Is either of these feasible, and what would be the best way to
accomplish?
I appreciate any help!
|