B
BAKERSMAN
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.
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.