Hi,
I use the "Free 3 of 9" font for making barcodes from text in excel.
Now I need to prepare barcodes from values, but some of these are decimal numbers, i.e. 10,15
The barcode looks like two barcodes separated by comma. How to do it correctly?
Hi,
I use the "Free 3 of 9" font for making barcodes from text in excel.
Now I need to prepare barcodes from values, but some of these are decimal numbers, i.e. 10,15
The barcode looks like two barcodes separated by comma. How to do it correctly?
Use SUBSTITUTE () function to replace comma with a dot.
Assuming your data is in Cell A1, write formula in B1:
=SUBSTITUTE(A1,",",".")
You will have 10.15 in B1.
Hope that's what you need.
Shashank Mishra
Please hit "Add Reputation" Button if you liked the answer.
ok,
But I transfer scanned values to the external software (ERP system).
I need to input there 10,15 instead of 10.15
Keep both the values in separate columns if that's possible.
I don't know about ERP but SAP offers a selection of columns in case of importing a file. If ERP offers the same, just select the appropriate column.
shank_mis I cannot understand,
Shortly speaking - I have some input field (does not matter if we consider SAP, other ERP, Excel cell or word, notepad or something) where I want to transfer the value 10,15 scanned from barcode.
The question is - how can I create the barcode for value 10,15 that after scanning and transfering to the input field it still will be 10,15 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks