How to add dot after numbering series?

kingston123 · #15 06-24-2020, 11:04 PM

Quote:

Originally Posted by ArviLaanemets

In case you want the numbering start from some other number (e.g. from 85), you can define a Name (Formulas > Name Manager) like FirstNo with '=85' in Refers to field, and then modify the series formula like

Code:

=(ROW()-ROW(tData[[#Headers];[Col1]]) + (FirstNo-1)) & "."

In case you want something different, you have to provide enough information.

I don't just need numbering, I need dot after that.

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