Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
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,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

See attached
Attached Files
File Type: xlsx previous_2.xlsx (9.5 KB, 7 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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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, 6 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,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

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,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

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,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

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,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

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,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

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,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

Is that a question or what.

Didn't you see my post #28?
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 03:02 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