Thread: How to add dot after numbering series?
View Single Post
 
Old 06-24-2020, 11:07 AM
kingston123 kingston123 is offline Windows 10 Office 2013
Advanced Beginner
  
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
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.

I did same as you told, it look this:


Reply With Quote