LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
 
Posts: n/a
Default

BarDoomed wrote...
You have gotten me another step forward James, now is there a way to

default
the "*" into the cells and have the data to enter between them? This

asking a
lot isn't it?

....

Your concern is display and printout, so you don't really need the
asterisks in the cells' contents. Since bar codes would be either
positive integers or text, use the custom number format (yes, NUMBER
format)

\*0\*;;;\*@\*

Positive numbers and text will display and print with delimiting
asterisks. Format these cells in barcode font and you should be good to
go.



 
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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Importing Data From Another Spreadsheet Tiziano Excel Discussion (Misc queries) 6 January 7th 05 02:35 AM
Entering data on template and then data going to a spreadsheet. KJH Excel Discussion (Misc queries) 3 December 24th 04 01:04 AM
How can I transpose data from a spreadsheet into a form that does. Joby Excel Worksheet Functions 3 November 30th 04 04:50 PM


All times are GMT +1. The time now is 09:55 AM.

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"