I'm trying to autofill the following and it keeps repeating, without
using a formula, only formatting, can someone help please?
when I put in: a20170000001, a20170000002, a20170000003, a20170000004,
it only repeats.
I can't use a custom list, as the fields will never repeat, only grow.
the only items changing will be the numeric value at the end, going up
to possibly 90,000 (ie; a20170090000)




--
rise and shine

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)