How to auto place start/stop characters in Excel w/barcode fonts?

I have a spreadsheet that I can enter in a value into one cell and it will
show the corresponding barcode value in the cell next to it, using 3 of 9
barcode font.
What I need to be able to do is have Excel automatically place a start and
stop charcter at each end of the barcode for my software to read the barcode.

did you include the asterisks http://www.bizfonts.com/free/
*314-34-1234*
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mel" <Mel@discussions.microsoft.com> wrote in message news:D29AA8C8-8375-4E13-8A96-DF9B1DAFDEDF@microsoft.com...
> I have a spreadsheet that I can enter in a value into one cell and it will
> show the corresponding barcode value in the cell next to it, using 3 of 9
> barcode font.
> What I need to be able to do is have Excel automatically place a start and
> stop charcter at each end of the barcode for my software to read the barcode.