Use Edit > Fill > Series to create the numbers. Use Format > Cells > Number > Format Code > "*"0"*"
to add the asterisks.
The cell values
will be the numbers but they will be displayed
with asterisks as explained in section 2. Controlling how data is displayed
of Ten concepts that every Calc user should know
. If your barcode process requires the cell values
to contain the asterisks, insert them with Data > Text to Columns
using field type Text. Then, since your cells have text, set Format > Cells > Number > Category > Text so that Calc won't use the apostrophe indicator when you view those cells in the Formula Bar.If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.6.8. The locale for any menus or Calc formulas in my posts is English (USA).