Partial editing of cell contents.

[Twinspar]

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?

 

[Don Guillett]

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.