My wife did a large spreadsheet for me collecting a bunch of data. All the cells have a little error flag on them saying they are text. I try to highlight and format cell to number but they will not change. The only way that works is to go to each cell, click on the error flag, convert to number.
Any suggestions?
