Whither double asterisk-inserting custom Excel formula??
May 6, 2009 2:36 PM Subscribe
Excel n00b needs help with what ought to be a very simple custom formula. And yes, I have looked around on the interwebs for the answer.
posted by wowbobwow to Computers & Internet (6 answers total) 1 user marked this as a favorite
I most humbly submit:
In order for me to print numbers as 'barcode 3 of 9' in a way that my scanner can read it, I have to add asterisks around it when it is still text. For example,
I have: 39020001341877
I need: *39020001341877*
One barcode per cell. It's like doing a find/replace for finding "all 14-digit numbers in all cells in this column" and replace with *asterisks around that number.*
I really need to be able to print them as readable, and I cannot alter how the scanner works, or other non-Excel related variables.
If that makes sense to anyone, and you might have an idea how to fix it, please let me know.
I am using Excel 2007 in Vista.