Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to add dot after numbering series?
Register FAQ

Reply
Page 2 of 3 1 2 3
 
Thread Tools Display Modes
  #16  
Old 06-24-2020, 11:07 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
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.

I did same as you told, it look this:



Reply With Quote
  #17  
Old 06-24-2020, 11:22 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,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
See attached
Attached Files
File Type: xlsx previous_2.xlsx (9.5 KB, 9 views)
Reply With Quote
  #18  
Old 06-24-2020, 11:48 AM
ArviLaanemets ArviLaanemets is offline How to add dot after numbering series? Windows 8 How to add dot after numbering series? Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
An example with Defined Table - Serie number is added automatically whenewer a new row is added. When any rows are deleted from table, Serie numbering is corrected automatically so numbers are alwais continuous.

To add rows into table, you
a) press Tab key with righmost field in last row active;
b) type info into any cell immediately below last row of Table, assured Table column doesn't contain formula;
c) insert a full row anywhere in Table's datarange;
d) select any cell of Table, and from Design menu click on Resize button. Enlarge the number of Table rows.
Attached Files
File Type: xlsx SerieNo.xlsx (9.2 KB, 8 views)
Reply With Quote
  #19  
Old 06-24-2020, 08:29 PM
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
See attached

That didn't help me, It's just a worksheet with serial numbers from 85.


My question is how to add dot after numbering series?
Reply With Quote
  #20  
Old 06-24-2020, 08:32 PM
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 ArviLaanemets View Post
An e......cell of Table, and from Design menu click on Resize button. Enlarge the number of Table rows.

Why did you add "blue" to your attachments? My question is not for colors. I am asking how to add dot after numbering series?
Reply With Quote
  #21  
Old 06-24-2020, 09:41 PM
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,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
Comment to your post #19

I simply don't know what you are talking about.
In the file attached to post #17 (previous_2) I entered 85. manually in cell A120 and then I entered the formula

=previous+1&"."

in cell A121 and copied this formula down to A126 whereafter these cells contain 86. 87. 88. 89. 90. and 91.

If that's not what you asked for in your original question then you must really explain better.
Reply With Quote
  #22  
Old 06-24-2020, 09:47 PM
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
Co......asked for in your original question then you must really explain better.

I think office 2013 gives me like this (using formula =previous+1&".") :





your using office 2016 that's why your trick not working for me (office 2013).
Reply With Quote
  #23  
Old 06-24-2020, 10:12 PM
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,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
No, that's not the reason.

What exactly do you have in Name Manager?
Reply With Quote
  #24  
Old 06-24-2020, 10:13 PM
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

what exactly do you have in name manager?

Code:
=mid(!a1,1,len(!a1)-1)
Reply With Quote
  #25  
Old 06-24-2020, 10:20 PM
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,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
So you haven't looked what I had in Name Manager in my workbokk in post #17.

=MID(Sheet1!A120,1,LEN(Sheet1!A120)-1)
Reply With Quote
  #26  
Old 06-24-2020, 10:27 PM
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,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
Before you enter the formula in post #25 above in Name Manager you must select cell A121.
Reply With Quote
  #27  
Old 06-24-2020, 10:36 PM
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
Before you enter the formula in post #25 above in Name Manager you must select cell A121.

That's what I did in post #10 including image also.
Reply With Quote
  #28  
Old 06-24-2020, 10:42 PM
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,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
If I shall try to help you any further then you must upload your own workbook so that I can see what you are doing wrong. It works absolutely fine for me.
Reply With Quote
  #29  
Old 06-24-2020, 10:50 PM
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
To use this formulae: previous+1&"." I need to edit Name Manager of A121.
Reply With Quote
  #30  
Old 06-24-2020, 10:52 PM
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,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
Is that a question or what.

Didn't you see my post #28?
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »


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 04:41 AM.

Contact Us - Privacy Statement - Top

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