Hello,
I am trying to create a barcode that needs to start with XX#
I have it working so that it populate with the XX# and a cell with a generated number in it to create the barcode
the only problem is that excel puts a space in the barcode where the # sign should be
Screenshot 2023-06-15 155739.png
It works in word but I cannot get it to work in excel, any suggestions?
Last edited by AliGW; 06-16-2023 at 01:05 AM. Reason: Thread title improved - generic thread titles are NOT permitted.
I suppose your barcode creator can not handle #
That is because they are restricted characters in Excel reserved for formula (i.e. @ & \ ) etc.,
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
@BigMike123 Can you post what Excel code you are trying to use?
How does this look: please see sample file.
Using: https://www.barcodesinc.com/free-barcode-font/
Free 3 of 9 Extended
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@BigMike123
Please refresh your knowledge of this forum's rules on thread titles: https://www.excelforum.com/forum-rul...rum-rules.html
Thank you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks