Thread: How to add dot after numbering series?
View Single Post
 
Old 06-24-2020, 09:01 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
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).
Attached Files
File Type: xlsx previous.xlsx (10.4 KB, 7 views)
Reply With Quote