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)
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)
Hi Marco,
There are several was of getting an incremented number of the type you're looking for. Here are examples:
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.
Regards,
Barry
Hi Barry,
thank you for your answer. This is the setting I used before
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.
Automatic would be nice, but it's not avaiable.
Pages '09 offered several styles for hierarchical lists like this, but in the current version, there appear to be only two:
Letters:
And Numbers:
List styles apply to lists in the body of a word processing document, and do not carry over into tables.
Regards,
Barry
I cannot use pages because it's a sheet like exel. But anyway, is there a possibility to make something like that:
"1.1." (fixed text) and then a number 1 (not linked to any row) that increase automatically?
"[I]s there a possibility to make something like that:
"1.1." (fixed text) and then a number 1 (not linked to any row) that increase automatically?"
See the third example (the one in column D) in my earlier post.
Regards,
Barry
But "bullet" doesn't have the "."
...And "." won't produce a string that increments.
Copy the string below. Paste it into a cell. Fill down.
1∙1∙1
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∙2∙1
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
Samples ending in 1 pasted in place, then filled down for three rows.
Regards,
Barry
Great! That works! Thanks!! 🙂
sequential numbering with prefix