I have a cell containing a seven digit number (A1) that will be used to create a barcode. In order to do this, I need an asterisk at the beginning and at the end of each number (i.e. from 1234567 to *1234567*). Normally I would just type in the asterisks but I'm dealing with over 18000 rows.
I've tried using the following formula in another cell starting at C1 and continuing on down but when the resulting cells are converted to barcodes, the formula is displayed and not the number.
Any ideas on how to do this?