Results 1 to 6 of 6

how to keep in standard sequential number?

Threaded View

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    how to keep in standard sequential number?

    Hi.
    When you change the year in "D3" in addition, the reset sequence (year 0000).
    I need to keep the format of 4 digits (0000)

    Run my code and then I change the year in "D3" secuencia will see that is not in the standard 4-digit

    Pattern
    13-2327
    13-2328
    13-2329
    13-2330
    13-2331
    13-2332
    13-2333
    13-2334
    13-2335
    13-2336
    14-7 14-0001 if the year change the sequence must start from Zero
    14-8 14-0002 and the format 4 digits after the dash (-)
    14-9 14-0003
    14-10 14-0004
    14-11 14-0005
    14-12 14-0006
    Attached Files Attached Files
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 10-30-2013, 07:29 PM
  2. Sequential Number macro
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2010, 05:36 PM
  3. [SOLVED] Sequential number within excel
    By Dev in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2006, 03:00 PM
  4. sequential number
    By Malissa in forum Excel General
    Replies: 3
    Last Post: 08-15-2005, 05:05 PM
  5. [SOLVED] sequential number
    By Mike W in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-12-2005, 07:06 PM

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