How to add dot after numbering series?

		Microsoft Office Forums > Microsoft Excel > Excel
How to add dot after numbering series?

FAQ

Thread Tools

Display Modes

06-24-2020, 06:59 AM

xor

Windows 10 How to add dot after numbering series?

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:34 AM.