I use the barcodefont for several applications. But i couldn't scan the
printed barcode...(with barcode scanner)
Therefore i had to concatenate the cell date with an * example: "*"&A1&"*"
this all works fine and i can generate and scan all barcodes....
BUT:
now I want to generate a date barcode (example: 10/02/09) that i can scan
with the barcodescanner...
I can generate and print the date barcode but it can not be scanned...
so i had to concatenate it again with "*"& &"*" but than i loose the
date format! Excel converts the date automatically into a numeric value wich
i cannot change with the cell format!

Use

="*"&TEXT(A1,"mm/dd/yy")&"*"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steven W" <Steven wrote in message
...
I use the barcodefont for several applications. But i couldn't scan the
printed barcode...(with barcode scanner)
Therefore i had to concatenate the cell date with an * example:
"*"&A1&"*"
this all works fine and i can generate and scan all barcodes....
BUT:
now I want to generate a date barcode (example: 10/02/09) that i can scan
with the barcodescanner...
I can generate and print the date barcode but it can not be scanned...
so i had to concatenate it again with "*"& &"*" but than i loose the
date format! Excel converts the date automatically into a numeric value
wich
i cannot change with the cell format!