Forum Discussion
Disable sequential numbering on a column
Hi everyone. I have some column in tables with number that no matter how much data I add they will always have the same value "4435" if I keep scrolling it will automatically add an extra value, 4435...4436 etc. I want that column to automatically add 4435 when I expand it and NOT increase the number.
3 Replies
Ocasio27 I suspect that your numer 4435 is actually a text. Scrolling will not change values, so I assume you mean "copying down the value by dragging the fill-handle". If you do that on a text with a numbers in the end it will automatically increase be 1. I'm on a Mac and can over-ride this default action by pressing Alt while dragging the fill-handle.
Try ISTEXT(cell reference). If the outcome is TRUE, you know for sure that it's not a number.
Im on windows, I try alt and does not work but I try ctrl and it works fine thanks for the tip.
