Hi,
I receive data each week that comes in Excel, but apparently from another system called Qlikview before that (which I don't have access to). One of the columns is called %TE and can have values such as
0%
10%
66.6666667%
or blank
They are left justified, there is no set number of decimal...