How to change back to A1 format because Excel is in R1C1 format by itself.
Have you ever opened a lot of Excel and before you know it, it’s in R1C1 format?
Both matrices are now numbers, and it’s hard to tell if it’s because they are different from usual.
Apparently, you’ve been hanging on to other books? It seems that this can happen. (I haven’t confirmed it yet.) I’m not sure about the expression “R1C1 format”.
I don’t understand the expression “R1C1 format”… I guess it means “row” and “column” format.
To revert for now, open Excel’s options by selecting “File” – “Options”.
Uncheck “Use R1C1 reference format.
コメント