How to add dot after numbering series?

kingston123 · #1 06-24-2020, 08:35 AM

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 · #2 06-24-2020, 09:01 AM

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 · #3 06-24-2020, 10:02 AM

Quote:

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleted entire row, but numbering series gone wrong. Help me.	kingston123	Excel	16	06-25-2020 08:16 AM
Set up Series of events	GreenBoy	Outlook	1	07-09-2018 04:43 PM
Series numbering	ericjowens	Excel	2	09-03-2015 11:20 AM
Fill Series	alamorchgirl	Excel	1	08-15-2011 10:05 AM
Data Series	Zach	Excel	1	11-05-2010 02:45 PM