![]() |
|
#16
|
|||
|
|||
|
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.'. |
|
|
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 |
Series numbering
|
ericjowens | Excel | 2 | 09-03-2015 11:20 AM |
Fill Series
|
alamorchgirl | Excel | 1 | 08-15-2011 10:05 AM |
| Data Series | Zach | Excel | 1 | 11-05-2010 02:45 PM |