bar code list

[msheyworth]

I am making a bar code list of serial numbers to use with a scanner is there a way of series filling when the number has to start and Finish with a * ie *abc123* the * are check marks for the scanner to work i think because it will not read without them or will i have to type them out individually

[mth]

Hello,

May be like this ?:



With this formula in B1:

="*"&A1&"*"

m

[msheyworth]

thanks that works