Help with Shortened Barcodes

Wakerra

New Member
Joined
Jul 12, 2017
Messages
1
I've been trying to set up a spreadsheet that will have one cell that pulls data from a list in a separate sheet, and another cell that transforms the pulled data in to a barcode. I've got the right font, I've played with various formulas and macros, but every time I get this Untitled - Wakerra's Sta.sh That weird looking comma thing is apparently a sort of abbreviation for the barcode, it prevents the whole thing from showing up. When I copy that cell and paste special, I get "¶B-12-1-002f¸". I've tried googling and searching for that odd little symbol at the end, but nothing comes back. What's even weirder, when I sent this spreadsheet to our tech for help, he was able to open the document and see the full barcode without an abbreviation. I'm suspecting this has something to do with the settings on my Excel, but I can't figure where the heck to fix it! Has anyone else seen this/know how to stop it??
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
I, too, am new to Mr. Excel but I did a quick search regarding the symbol. It is called a cedilla. Take a look at an ASCII chart for more assistance. As far as the format goes, take a look at the format on your tech's computer if that is possible one more time. Is there any barcode software installed on your tech's computer? It is worth a shot. I have had similar problems with some of the third party barcode software packages.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top