Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
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: 960
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



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
 



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 07:13 PM.


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