I have had to create a custom form in Excel that goes out and queries a database on our iSeries (v7r1). The user will enter in a number which as to surround by single quotes. I can hardcode the number (with quotes) into the query and it works fine but I cannot figure out how to get get it work with the variable. Also, I am having problems getting the date field to display in regular American date format instead of the iSeries format.

And I have one last issue. I have field that is constantly returning extra spaces at the end of a word.

Any help would be greatly appreciated.

Thank you in advance!