Filling series for a cell containing "m³" leads to strange results
If you have a cell that contains "m³" (without quotes) and you use the fill handle to fill cells below or to the right, you will get "m132", "m133", etc. Similarly, if you fill cells above or to the left, you will get "m130", "m129", etc. "m³" acts as if its value is "m131", which is clearly incorrect behaviour.
There are probably many other examples where filling series acts weird. Please fix this. There are 2 acceptable solutions. One is to simply copy "m³" to the destination cells. The other is to treat the "³" like "3" and assume the following series:
… m⁻¹, m⁰, m¹, m², m³, m⁴, m⁵ …
One wonders just how this came about, what purpose was served where.
Works with the ² which it seems to regard as "130" and by themselves, no need for a character to go with them. ODD. Consistent though so... what? And the generated 128, say, is really three digits not a single character somehow, LEN()=3 as well as being editable. And taking "m128" and filling down does not yield it, even in its original cell.
I was thinking of the 130, for instance, as being 48 less than the character's CODE() value, but while writing below, I realized it is 128 + 2 and while 48 doesn't really suggest anything, 128 (2^7) does. and 131 is 128 + 3.
But it does not happen with the nearby characters that are not "number-looking" just them. Tried about 20 others, including the later series of superscripted numerals. Those last did NOT do this. So it could be unique to these two, maybe.
Superscripting a "3" next to the "m" using in-cell formatting yeilds a nice series like the second result option offered above. The numbers count up and down as appropriate.
It also fills this way left and right (left = upward fill, right = downward fill for how the number part goes).
Nothing I found about it suggests Excel regards it as a number except what Mr. Barber found. When it fills using ONLY the ² or ³, the filled in cells have numbers that are displaying as if text, but that are General format. They are in that limbo you can get when you try the Paste|Special|Multiply (by 1, or P|S|Add by 0) trick and... it doesn't seem to work. It DID, but did not finish it by forcing Excel to refigure how to display them. And when it happens, many functions fail (like VLOOKUP() if it presents a numeral vs. a numeral formatted as text). The fill cells are in that limbo right from the start.
Interesting. But should be fixed. Or explained and its benefit expounded on.