Microsoft Office Forums - View Single Post - How to add dot after numbering series?

Thread: How to add dot after numbering series?

View Single Post

Old

06-24-2020, 10:02 AM

kingston123 kingston123 is offline

kingston123 is offline

kingston123 uses Windows 10

Windows 10 kingston123 uses Office 2013

kingston123 uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Sep 2018

Posts: 85

kingston123 is on a distinguished road

Default

Quote:

Originally Posted by xor

View Post

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).

Thanks, but how to import your attached worksheet settings to my worksheet?

Reply With Quote