Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |