"!" in INPUT and VAL

VAL() and INPUT (with numbers) will stop reading a string after encountering certain characters, such as ! and %. For example, VAL("123ABC") is 0, but VAL("123!ABC") is 123.