Thread
:
How to add dot after numbering series?
View Single Post
06-24-2020, 09:01 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,100
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
previous.xlsx
(10.4 KB, 7 views)
xor
View Public Profile
Find all posts by xor