Thread: How to add dot after numbering series?
View Single Post
 
Old 06-24-2020, 11:00 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote