Originally Posted by Vasu
|
Try typing 1 followed by some random text, then left-click drag it. You'll see what I mean.
Eg: 1 star gets dragged down to '2 star', '3 start' etc.
|
Yup.
Yet if you just type 1, and drag, you get 1, 1, 1, 1....
I think it has something to do with the format of the cell. Excel recognise "1 star" to be
text, and when you drag that it goes 1 star, 2 star, 3 star..
but when you just type 1, it recognise it as
number (usually the number are automatically right aligned as well) and it just goes 1, 1, 1, 1....
Strange that it thinks text need sequence, but number doesn't... I couldn't figure out that logic... but that's now it seems to work..