LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default convert data into barcode

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht Excel Worksheet Functions 2 May 15th 23 11:42 AM
Convert My Data into Barcode 128 B Safi Excel Worksheet Functions 1 August 9th 06 07:23 PM
UDF for Data into 128 B barcode problem Safi Excel Worksheet Functions 1 August 1st 06 07:54 PM
Convert arial text field to barcode bob engler Excel Worksheet Functions 1 July 7th 06 08:29 AM
Spreadsheet with readable barcode data when printed. BarDoomed Excel Worksheet Functions 6 January 7th 05 08:11 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"