I tried that. It was maddening. All the stuff the normally works did not work. I think this was caused by quickbooks. It was a QB report exported as excel. On the web, this problem is normally associated with a data export.
From: George Skorup Sent: Thursday, July 14, 2016 5:52 PM To: [email protected] Subject: Re: [AFMUG] Fw: OT Excel arrgh Couldn't you select the whole sheet and convert it to numeric? Shouldn't bother any cells with text. On 7/14/2016 6:43 PM, [email protected] wrote: Here is the solution: When highlighting an area that has some of these goofy cells in it, make sure the upper left cell of the area is a goofy cell. Then the error flag appears and you can fix the whole area. Have never seen this before. From: [email protected] Sent: Thursday, July 14, 2016 5:34 PM To: [email protected] Subject: Re: [AFMUG] OT Excel arrgh 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?
