I have a field programmed in Vendor Name on element entry and populates with a list as follows:

var vList as String 
     
vList = @XLookupSourceListAll(@FN, "..", "VENDORS!VENDOR NAME", "VENDOR NAME;REFERENCE;VENDOR#") 
vList = @Replace(vList, ";", " - ")          // replaces ;separated values with a " -  "
vList = @Replace(vList, @Newline(), ";")          // inserts newline in list
vList = @SortStringArray(vList, 0)                //0 = ASCII sort, 1 = Number sort   
PopulateListElement(VENDOR NAME, vList)   

I recently added Vendor# to the list so that I could strip out the number into the Vendor# fields (we have some vendors where payments go to different locations and therefore unique vendor records).

It works fine but my problem is that Vendor# (number type field) appears at the end of the source list as follows with 6 decimal places:  ie.  230.000000.

Is there a way to eliminate the decimal and zero's other than changing the field to a text field ?

When I strip out the Vendor# (on vendor Name element change), I used 10 places to the right of Vendor Name, so it shows correctly as 230

Thanks,

Louis

Erika:

That was too easy ! and it works great.

Thanks,

Louis