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] <mailto:[email protected]>
*Sent:* Thursday, July 14, 2016 5:34 PM
*To:* [email protected] <mailto:[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 <mailto:[email protected]>
*Sent:* Thursday, July 14, 2016 5:30 PM
*To:* [email protected] <mailto:[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] <mailto:[email protected]>> wrote:
Tried both. Areas. Even single cells.
*From:* Bill Prince <mailto:[email protected]>
*Sent:* Thursday, July 14, 2016 5:23 PM
*To:* [email protected] <mailto:[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] <mailto:[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?
