You would think! I really wish text to numbers was a right click operation and not like Chuck's solution (which is what I do when I see this all the time).
On Jul 14, 2016 7:52 PM, "George Skorup" <[email protected]> wrote: > 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 <[email protected]> > *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 <[email protected]> >> *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? >> >> >> >
