Excel Problem
You guys have been so helpful in the past. I have owned a Mac since forever it seems, as I am 67. I teach at a University, and as you know, until recently, was ONLY PC.
I have been entering data into Excel, saved it, and now each new version updates two columns of numbers. One column was the subject number, and I entered 101, 102, etc into the spreadsheet. But it automatically converts these into 404, 408, etc, and on each new copy multiplies more, I think.
I also entered a column for a person's age, and it is multiplying those numbers too! !
There must be some setting that converts the numbers based on some list setting.
Gad !
????????
I have been entering data into Excel, saved it, and now each new version updates two columns of numbers. One column was the subject number, and I entered 101, 102, etc into the spreadsheet. But it automatically converts these into 404, 408, etc, and on each new copy multiplies more, I think.
I also entered a column for a person's age, and it is multiplying those numbers too! !
There must be some setting that converts the numbers based on some list setting.
Gad !
????????
Comments
They do have their uses though because to write out the list of numbers, you can do something like the following:
A1 = 101
A2 = A1+1
Then when you do a column fill, below A2, subsequent cells will get things like A5 = A4+1. This way, you only have to fill in two actual cells but you can populate hundreds of cells with the data you want.