how about copying the whole sheet and pasting "values" to a new sheet? If you don't carry over the formatting it should work.
On Thu, Jul 14, 2016 at 7:19 PM, Andrew Haninger <[email protected]> wrote: > 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? >>> >>> >>> >>
