Instead of allowing them into the cell to edit you could use a inputbox
macro to ask for the number and have the macro insert the new number.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Twinspar" wrote in message
...
I am developing a spreadsheet to be distributed to numerous individuals for
updating and returned to me to be compiled. I have a column for account
number which consists of a 6-segment number, each segment separated by
hyphens. I need recipients to edit the middle two segments and return to
me.
I want to create another column that duplicates the account number string
except for the middle two segments, and either highlight the segments to
be
edited or mask the two segments to ensure correct number of digits are
entered for the segments. How can I accomplish this?
--
Twinspar