I am rereading your original post and I am now confused. Probably
because there is a certain package for barcodes I am not aware of.

Is there a chance that TEXT(number, "000000") will help you? Beyond
this I am running out of suggestions. Maybe, if you give details of the
application you are using and post in another Excel group (e.g.
programming) you will get a better answer.

Regards,
Kostis Vezerides