Hi,
I'm creating a sheet to take info from a series of column, use concatenate to create a text string from the info, then a vlookup to find a template name from the string. But what I need to do is limit the data to only the type that is expected from the columns. If someone means 11, I need it to say '11', not 'eleven' not '11.00', not 'XI'.
I've used formatting and data verification to limit the type of data that can be input, but I'm aware it's still possible to copy and paste into the cells as that brings the formatting from the originating cell.
So, is there any way to prevent data being pasted into a cell, but still allow manual input?
Thanks in advance
I'm creating a sheet to take info from a series of column, use concatenate to create a text string from the info, then a vlookup to find a template name from the string. But what I need to do is limit the data to only the type that is expected from the columns. If someone means 11, I need it to say '11', not 'eleven' not '11.00', not 'XI'.
I've used formatting and data verification to limit the type of data that can be input, but I'm aware it's still possible to copy and paste into the cells as that brings the formatting from the originating cell.
So, is there any way to prevent data being pasted into a cell, but still allow manual input?
Thanks in advance