A a14929 Registered User. Local time Today, 09:16 Joined Apr 9, 2000 Messages 11 Apr 16, 2000 #1 Autonumber goes up in the 1,2,3... sequence. Is there any way to customise this to another code like BS0001, BS0002, BS0003?
Autonumber goes up in the 1,2,3... sequence. Is there any way to customise this to another code like BS0001, BS0002, BS0003?
P Pat Hartman Super Moderator Staff member Local time Today, 04:16 Joined Feb 19, 2002 Messages 47,602 Apr 16, 2000 #2 Keep a second column to contain your alpha prefix and concatinate the two columns for display purposes. Use the Format() function to get leading zeros for the numeric portion.
Keep a second column to contain your alpha prefix and concatinate the two columns for display purposes. Use the Format() function to get leading zeros for the numeric portion.
