Not that I can see. The error says they are text. But you cannot format to convert to number. They look just fine. I discovered if I highlight a group of them, the error flag shows up and I can convert the whole group to a number. But the whole spreadsheet is riddled with these non numeric cells. And if you include a good number when highlighting an error, the flag does not show.
From: Andrew Haninger Sent: Thursday, July 14, 2016 5:30 PM To: [email protected] Subject: Re: [AFMUG] OT Excel arrgh Do the values start with apostrophes? That's one trick to force Excel to treat numbers as text and the apostrophes only appear when editing the cell. You could also try a =value(A1) formula in a different cell. Andy On Jul 14, 2016 7:25 PM, <[email protected]> wrote: Tried both. Areas. Even single cells. From: Bill Prince Sent: Thursday, July 14, 2016 5:23 PM To: [email protected] Subject: Re: [AFMUG] OT Excel arrgh What if you just do a column or row? bp <part15sbs{at}gmail{dot}com> On 7/14/2016 4:20 PM, [email protected] wrote: 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?
