I assume that data validation (Excel menu: Data- Validation) on the
worksheet is not an option; therefore, how about checking that the
third character from the right is a decimal point? Something like
if mid(cell, len(cell)-2, 1) < "."