Hmmm, I’ll bet that would have worked. From: Cameron Crum Sent: Thursday, July 14, 2016 11:13 PM To: [email protected] Subject: Re: [AFMUG] Fw: OT Excel arrgh
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 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?
