The line item "416 23687" which is "416" [space] 23687" translates to 41623687
using the =val("416 23687") function. Also the following also returns an
unexpected result:
=val("416 0.23687"). This returns the value of 4160.23687 instead of the
expected Acct#416 with Count Qty of 0.23687.

Next question:
Is the Acct# a separate column 'field' in the data? If so, the Val(Acct#) will
work. Otherwise the strategy to 'scan' the data item content for a non-numeric
character still applies!