+ Reply to Thread
Results 1 to 2 of 2

How do I generate a set text and an increasing number in a column?

  1. #1
    Registered User
    Join Date
    03-24-2005
    Posts
    5

    How do I generate a set text and an increasing number in a column?

    Hi

    I want to generate this

    COB-01/04
    COB-02/04
    COB-03/04

    and so on in a column but I have absolutely no idea how to do it or if it is even possible. If anyone can help me I'll be delighted

    thanks a lot!

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    I would use 3 columns: COB- in first, 01 in second, and /04 in third column. Close the column widths up. COB- and /04 can be filled down and remain unchanged, 01 can be filled in series. The problem I found with trying to put COB-01/04 in a single cell was that the cell became text, and the /04 was treated as a year, so getting /04, /05, /06, and so on, yet 01 stayed as 01.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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