Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2020, 04:41 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default How to add dot after numbering series?

I add numbering series by using "fill" but it didn't create dot after series. How to add dot after series?





Reply With Quote
  #2  
Old 06-24-2020, 06:59 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

With 85. in A1 go to Name Manager and select A2

Name: previous
In the Refers to field insert: =MID(Sheet1!A1,1,LEN(Sheet1!A1)-1)
Close

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

This formula can handle if you delete rows.
Reply With Quote
  #3  
Old 06-24-2020, 08:35 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

Tell me If I am wrong, I selected cell A120, I clicked " Name Manager" under "Formulas" tab.

Now I clicked "New", dialog box came like this, so I edited same as your code:






If this one is right, then I will go next step. I will wait for you reply.
Reply With Quote
  #4  
Old 06-24-2020, 08:51 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

Yes, this one is right.
Reply With Quote
  #5  
Old 06-24-2020, 09:01 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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, 5 views)
Reply With Quote
  #6  
Old 06-24-2020, 10:02 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
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
  #7  
Old 06-24-2020, 10:12 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

Not understood.

What is the problem?
Reply With Quote
  #8  
Old 06-24-2020, 10:16 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Not understood.

What is the problem?

You attached worksheet with some Name Manager codes included, how to transfer those code into my worksheet?
Reply With Quote
  #9  
Old 06-24-2020, 10:20 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

You must type it in manually in the Name Manager of your workbook.
Reply With Quote
  #10  
Old 06-24-2020, 10:31 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

After this what should i do?



Reply With Quote
  #11  
Old 06-24-2020, 10:37 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

As I wrote in #2

Now in A2 use the formula:=previous+1&"." and copy down.
Reply With Quote
  #12  
Old 06-24-2020, 10:42 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
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
  #13  
Old 06-24-2020, 10:53 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

Haven't you at all read what I wrote in #2?
I assumed you had 85. in A1. If you have 85. somewhere else this should be reflected in the formula in the Name Manager.
Reply With Quote
  #14  
Old 06-24-2020, 11:00 AM
xor xor is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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
  #15  
Old 06-24-2020, 11:00 AM
kingston123 kingston123 is offline How to add dot after numbering series? Windows 10 How to add dot after numbering series? Office 2013
Advanced Beginner
How to add dot after numbering series?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Have...er.

A1 to A120 all numbers are fine. problem is at A121 which does not have dot after serial number.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleted entire row, but numbering series gone wrong. Help me. kingston123 Excel 16 06-25-2020 08:16 AM
Set up Series of events GreenBoy Outlook 1 07-09-2018 04:43 PM
How to add dot after numbering series? Series numbering ericjowens Excel 2 09-03-2015 11:20 AM
How to add dot after numbering series? Fill Series alamorchgirl Excel 1 08-15-2011 10:05 AM
Data Series Zach Excel 1 11-05-2010 02:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft