Restrict Cell Entry
I have a spreadsheet cell that I would like to restrict entries of:
m, M, f, F, only.
I have data validation set up for the cell listing those 4 entries.
When ever someone enters a name such as matthew or Mary, the auto correct will
change the m entry into matthew.
Turning off the "AutoCorrect" is NOT an option.
Is there another way of limiting entries into this cell for the 4 entries listed above
thanks for any help
Cardinal 32
|