sequential numbering with prefix

hi,


this is my case:


1.1 TITILE (1.1 I will add it manual)


1.1.1 (1.1 it should pick from above and add .1)

1.1.2 (then it should count)

1.1.3

...


thanks

MacBook Pro with Retina display, OS X El Capitan (10.11.4)

Posted on Apr 21, 2016 1:58 PM

Reply
8 replies

Apr 21, 2016 6:06 PM in response to marco.acri

Hi Marco,


There are several was of getting an incremented number of the type you're looking for. Here are examples:

User uploaded file

The first, in column B shows what happens if you enter the initial 'number' just as shown, then fill it down: The contents of succeding cells shows no change from the original.


In column C, a text string ending in a numeral (A1) was entered in C2, then filled down. This pttern results in the expected increment of 1 per row as the contents are filled down the column, but it doesn't fit the pattern you requested.

In column D, the two periods are replaced with characters named "bullet operator." When filled down, these characters make the entry act like a text string ending in a numeral, and he final number increments as in column B.


The last example, in column E, uses a formula. enter as shown in E2, then fill down the through the rest of the cells where it is needed. f you are strting in a cell in a different row than 2, adjust the "-1" to giv you the correct result in your starting cell.

E2: ="1.1."&ROW()-1


If you choose the example in column D, here is where you will find the "bullet operator." To insert one in a document, grab it from the table (where it's the shaded one), drag it to where you want it, then drop it by releasing the mouse button.

User uploaded file

Regards,

Barry

Apr 22, 2016 12:09 AM in response to Barry

Hi Barry,


thank you for your answer. This is the setting I used before

User uploaded file

In this case that seems to be close to your suggestion I have to change in every sub-paragraph the fixed cell for reference and the number to starting from .1. Then I can grab the cell down and it increase automatically.


The problem using this code are:


- I have to insert manually the first reference (1.1 or 1.2). It would be nice to find a way to copy the text 2 cell up.

- I have to insert manually the number (-3, -11). This is first boring and second not efficient, for example, if I add a row between 1.1.3 and 1.1.4 than the text 1.2.1 it change in 1.2.2.

Apr 22, 2016 2:36 AM in response to marco.acri

...And "." won't produce a string that increments.


Copy the string below. Paste it into a cell. Fill down.

1∙11


For the next subset, Copy, Paste, then edit the digit that needs a new value,as I've done here with the second digit. Fill down.

1∙21

The examples above use the unicode character U+2219

You might also try unicode U+2024, "one dot leader."

1․1․1

Edited:

1․3․1

User uploaded file

Samples ending in 1 pasted in place, then filled down for three rows.

Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

sequential numbering with prefix

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.