How to add dot after numbering series?

[kingston123]

I add numbering series by using "fill" but it didn't create dot after series. How to add dot after series?

[xor]

With 85. in A1 go to Name Manager and select A2

Name: previous
In the Refers to field insert: =MID(Sheet1!A1,1,LEN(Sheet1!A1)-1)
Close

Now in A2 use the formula:=previous+1&"." and copy down.

This formula can handle if you delete rows.

[kingston123]

Tell me If I am wrong, I selected cell A120, I clicked " Name Manager" under "Formulas" tab.

Now I clicked "New", dialog box came like this, so I edited same as your code:






If this one is right, then I will go next step. I will wait for you reply.

[xor]

Yes, this one is right.

[xor]

Here is a file where I have made it possible to use the formula on any sheet in the workbook.

Formula in Name Manager: =MID(!A1,1,LEN(!A1)-1)

instead of: =MID(Sheet1!A1,1,LEN(Sheet1!A1)-1)

(the last one only works on Sheet1).

[kingston123]

Originally Posted by xor

Here is a file where I have made it possible to use the formula on any sheet in the workbook.

Formula in Name Manager: =MID(!A1,1,LEN(!A1)-1)

instead of: =MID(Sheet1!A1,1,LEN(Sheet1!A1)-1)

(the last one only works on Sheet1).

Thanks, but how to import your attached worksheet settings to my worksheet?

[xor]

Not understood.

What is the problem?

[kingston123]

Originally Posted by xor

Not understood.

What is the problem?

You attached worksheet with some Name Manager codes included, how to transfer those code into my worksheet?

[xor]

You must type it in manually in the Name Manager of your workbook.

[kingston123]

After this what should i do?

[xor]

As I wrote in #2

Now in A2 use the formula:=previous+1&"." and copy down.

[kingston123]

Originally Posted by xor

As I wrote in #2

Now in A2 use the formula:=previous+1&"." and copy down.

Why A2? My previous cells are fine with dots.

Problem arrives after A121 which has 86 serial number (without dot), A122 has 87 series number (without dot)........so on.

[xor]

Haven't you at all read what I wrote in #2?
I assumed you had 85. in A1. If you have 85. somewhere else this should be reflected in the formula in the Name Manager.

[xor]

Do you have 85. in A120?
If so, select A121
Paste this formula in the Refers to field in Name Manager: =MID(!A1,1,LEN(!A1)-1) and write previous in the Name field.
Close.

In cell A121 enter the formula: =previous+1&"." and copy down.

[kingston123]

Originally Posted by xor

Have...er.

A1 to A120 all numbers are fine. problem is at A121 which does not have dot after serial number.