Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #31  
Old 06-24-2020, 10:56 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
Is that a question or what.

Didn't you see my post #28?

I am asking what exactly I am missing in my code.
Reply With Quote
  #32  
Old 06-24-2020, 11:00 PM
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

Quote:
Originally Posted by kingston123 View Post
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?
It was an example how to get automatic numbering with dot at end. As you provided only a screenshot from middle of nowhere from your worksheet, I had nothing to work with at all. So I created a fake Table to show what you have to do.

You can add any number of rows above Table, so the Table starts e.g. from any row. You can have any info entered into rows at top of Table, assured you leave the row immediately above Table table headers empty. What is entered into Table columns right at serials doesn't count at all - it doesn't affect how serials are calculated.

In case you want the numbering start from some other number (e.g. from 85), you can define a Name (Formulas > Name Manager) like FirstNo with '=85' in Refers to field, and then modify the series formula like
Code:
=(ROW()-ROW(tData[[#Headers];[Serie]]) + (FirstNo-1)) & "."
In case you want something different, you have to provide enough information.

Quote:
Why did you add "blue" to your attachments? My question is not for colors. I am asking how to add dot after numbering series

What do you mean here? Why odd and even rows are colored differently? This is how defined Table behaves. Blue is default color, but you can select different color schemes when you want - I never bother.

Btw. When I write 'table', then I mean a table you get when you enter some column headers into worksheet, and the you enter some data into those columns below header row. When I write 'Table', then I mean you select any cell of your table, and then you select from menu Insert>Table, confirm that you want to create a Table, and that the Table will have a header row. And preferably you edit the name of Table in some meaningful way - by default Tables are named like Table1, Table2, etc. Later you can access Table properties from Design menu, which is displayed whenever you activate any cell in Table.
Reply With Quote
  #33  
Old 06-24-2020, 11:04 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
In case you want the numbering start from some other number (e.g. from 85), you can define a Name (Formulas > Name Manager) like FirstNo with '=85' in Refers to field, and then modify the series formula like
Code:
=(ROW()-ROW(tData[[#Headers];[Col1]]) + (FirstNo-1)) & "."
In case you want something different, you have to provide enough information.

I don't just need numbering, I need dot after that.
Reply With Quote
  #34  
Old 06-24-2020, 11:13 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

Quote:
Originally Posted by kingston123 View Post
I am asking what exactly I am missing in my code.

You don't want to cooperate so neither do I any more.
Reply With Quote
  #35  
Old 06-24-2020, 11:16 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
You don't want to cooperate so neither do I any more.

I am posting images. What else do I need to do?
Reply With Quote
  #36  
Old 06-24-2020, 11:23 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 it so difficult to understand that you should upload your own workbook (Go Advanced) so that I can see what you are doing wrong (as I wrote in my post #28). Pictures aren't of much help.
Reply With Quote
  #37  
Old 06-24-2020, 11:28 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
Is it so difficult to understand that you should upload your own workbook (Go Advanced) so that I can see what you are doing wrong (as I wrote in my post #28). Pictures aren't of much help.

Pictures are helpful, why can't you post pictures like this (step by step)?
Reply With Quote
  #38  
Old 06-24-2020, 11:49 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

Deleted again
Reply With Quote
  #39  
Old 06-24-2020, 11:56 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
Deleted again

Deleted what again ?
Reply With Quote
  #40  
Old 06-24-2020, 11:59 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

As explained many times before.

previous.PNG
Reply With Quote
  #41  
Old 06-25-2020, 12:28 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

If your sheet has some other name than Sheet1 you must of course change the formula in Name Manager accordingly.
Reply With Quote
  #42  
Old 06-25-2020, 12:30 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 explained many times before.

Attachment 15282

Should I create "new name?, Because blank window comes up when I click "Name manager" after I select A121.



Reply With Quote
  #43  
Old 06-25-2020, 12:32 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

Click New.
Reply With Quote
  #44  
Old 06-25-2020, 03:06 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 you should create a new name. I thought you had done that a long time ago according to your earlier messages.
Reply With Quote
  #45  
Old 06-25-2020, 03:59 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

Quote:
Originally Posted by kingston123 View Post
I don't just need numbering, I need dot after that.
You need dot after what?

After you enter any number into any cell in column A?
Format column A as Custom, Type = 0\.
Now whenever you enter any number into column A, it is displayed like '1.', or '85.', or '999.'. At same time, it is really a number, i.e. when you sort your table by column A e.g. in ascending order, then e.g. 11 > 2. It's value really doesn't contain any dots, the dot after number is only displayed. And whenever you refer to Column A cell values in formulas, you have to use numbers without dot. And when you delete row(s), values in column A are not recalculated automatically.

All other solutions (where cell value contains a dot) assume you use some formula in column A. And this means you don't enter values into column A - they must be calculated by formula (or inserted by VBA script, but closest events you can use for this are worksheet events, which are running whenever you change something in any cell in worksheet (this may slow down your workbook performance considerably)). And such value is really a text, i.e. when you sort your table by column A e.g. in ascending order, then e.g. '11.' < '2.'.
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:25 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