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:42 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

As I wrote in #2

Now in A2 use the formula:=previous+1&"." and copy down.

Why A2? My previous cells are fine with dots.

Problem arrives after A121 which has 86 serial number (without dot), A122 has 87 series number (without dot)........so on.

Reply With Quote