by osknows » Tue May 25, 2010 5:21 pm
Hi Chad,
Once linked to excel I believe the form comes out around column AA on the spreadsheet
If form was something like 0-68429 in column AA, you can use a formulae
=right(AA5,1) (outputs 9 as text)
=right(AA5,1)*1 (outputs 9 as numeric)
=IF(ISERROR(RIGHT(AA5,1)*1),RIGHT(AA5,1),RIGHT(AA5,1)*1) (outputs numeric 9 with error checking if not a number)