I have become the 'victim' of some unforseen behavior convering the 'VAL' function. The return from Val('1234567A') is 1234567 and the return from Val('1234567E') is 1234567 but the return from VAL('1234567E01') is 12345670. In other words, the val function interpets the letter 'E' followed by numbers as being scientific notation. Is this a feature or a bug?
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!