Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to convert data from specific cells into a barcode. I have the
correct barcode font loaded but cannot seem to get a couple of the cells to give me the correct data. For instance, one of the cells is a date. When I try to add this cell to the formula, instead of the date I see 239918. I also have a cell that has to be 2 characters. When I try to add this cell to the formula, it will only return 1 character unless the number is a bove 9. I have the cell formatted where it shows to characters (ex. 02) but always returns only one character(ex. 2). Here is the formula I am using. ="*"&F7&R7&B15&R23&R15&"*" B15 is the cell that should be two characters and R23 is the cell that is the date. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to convert list of numbers to barcode font | Excel Worksheet Functions | |||
Convert My Data into Barcode 128 B | Excel Worksheet Functions | |||
UDF for Data into 128 B barcode problem | Excel Worksheet Functions | |||
Convert arial text field to barcode | Excel Worksheet Functions | |||
Spreadsheet with readable barcode data when printed. | Excel Worksheet Functions |