Hello,I am Pete, and I'll be happy to assist with your question today.
Do other people use the spreadsheet apart from yourself?
Could the data have been copied and pasted in, rather than typed?
There is a quick way to convert all cells to number, if you highlight the column downwards starting from the first affected cell, then select the yellow box to convert text to number it will convert all of the selected cells.
I can demonstrate remotely if you would prefer that?
The cause is how the data has been entered, e.g. if it has been copied and pasted from a text source.
Rows can be highlighted in seconds - this is the only global fix now that the data is already entered and you have formulas on the sheet.
I can demonstrate and fix remotely in seconds if you prefer.
As I have said previously, I can highlight and change ALL affected cells in the sheet within seconds.
Hi Bill, just checking in on your question - did my answer work?