I am not sure if this is in the scope of help from PC Advisor but would be grateful for help.
It's small but irritating problem!!!
I have opened a basic excel file supplied for me to teach with.
Two columns show with 'green' corners denoting an error. The error information icon says the numbers in the column are formatted as text. It allows me to select to convert them to number.
But here is the rub. I have to do each one of 60 individually. If I select them all and convert them to number by formatting the cells, the green corner error is still there!
And you should see the solution offered by Microsoft to convert a range of numbers with this problem, it's extraordinary, laughable even. It includes 7 steps, the first of which is to type '1' into an empty cell... it's downhill from thereon in.
If anyone can be kind enough to answer this I would be most grateful.