+ Reply to Thread
Results 1 to 8 of 8

I need help with creating a 12 character numeric series

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    I need help with creating a 12 character numeric series

    I'm creating a database that will be used to create a barcode. This barcode will encompass a part number followed by a sequential number.
    The part number 2600597 just needs the sequential numbers appended to the end.

    I'm about to pull my hair out, what's left of it.


    The column should look like this.

    number
    260059710001
    260059710002
    260059710003

    Numbering from 10001 to 60000

    Can anyone help me with this please?

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: I need help with creating a 12 character numeric series

    Put this in your first cell then drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: I need help with creating a 12 character numeric series

    I'm getting the same thing I get from the methods I've been using. Instead of the number I need I'm getting 26006E+11 in all cells producing a barcode that is incorrect.
    Attached Images Attached Images

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: I need help with creating a 12 character numeric series

    Try this
    Enter in A2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A
    1 260059710001
    2 260059710002
    3 260059710003
    4 260059710004
    5 260059710005
    6 260059710006
    7 260059710007
    8 260059710008
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: I need help with creating a 12 character numeric series

    That seemed to work until I got to 260059720000, where it gave me 2600597110000 instead.
    Attached Images Attached Images

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: I need help with creating a 12 character numeric series

    I see. Use formula suggest by Aardigspook. Just format cell as Number with no decimals

  7. #7
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: I need help with creating a 12 character numeric series

    Thanks you guys, that worked brilliantly.

  8. #8
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: I need help with creating a 12 character numeric series

    You're welcome. Sorry I didn't mention cell formatting in my first post. 'Number' format with no decimals or 'Custom' format of 000000000000 (12 zeroes) both work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If with numeric .AND. character?
    By mhornnoble in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2016, 11:28 AM
  2. Replies: 2
    Last Post: 11-11-2013, 05:37 PM
  3. [SOLVED] 3 Character Alpha Numeric Permutations
    By N8237 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2012, 10:00 PM
  4. Separate at first numeric character
    By sandersonsea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2009, 05:17 AM
  5. Keeping only numeric character?
    By ryanjensen03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2008, 02:54 PM
  6. [SOLVED] Assigning a numeric value to a alpha character
    By Johnny D in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2006, 03:10 PM
  7. [SOLVED] Determine if a character is numeric or non-numeric
    By AP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2005, 05:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1