Re: [AFMUG] Fw: OT Excel arrgh

[Chuck McCown]

Hmmm, I’ll  bet that would  have  worked.  

From: Cameron Crum 
Sent: Thursday, July 14, 2016 11:13 PM
To: af@afmug.com 
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 <ahan...@gmail.com> 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" <geo...@cbcast.com> 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, ch...@wbmfg.com 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: ch...@wbmfg.com 
  Sent: Thursday, July 14, 2016 5:34 PM
  To: af@afmug.com 
  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: af@afmug.com 
  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, <ch...@wbmfg.com> wrote:

Tried both.  Areas.  Even single cells.  

From: Bill Prince 
Sent: Thursday, July 14, 2016 5:23 PM
To: af@afmug.com 
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, ch...@wbmfg.com 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?

Re: [AFMUG] Fw: OT Excel arrgh

[Cameron Crum]

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  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"  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, ch...@wbmfg.com 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:* ch...@wbmfg.com
>> *Sent:* Thursday, July 14, 2016 5:34 PM
>> *To:* af@afmug.com
>> *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:* af@afmug.com
>> *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,  wrote:
>>
>>> Tried both.  Areas.  Even single cells.
>>>
>>> *From:* Bill Prince 
>>> *Sent:* Thursday, July 14, 2016 5:23 PM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT Excel arrgh
>>>
>>>
>>> What if you just do a column or row?
>>>
>>> bp
>>> 
>>>
>>>
>>> On 7/14/2016 4:20 PM, ch...@wbmfg.com 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?
>>>
>>>
>>>
>>

Re: [AFMUG] Fw: OT Excel arrgh

[Andrew Haninger]

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"  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, ch...@wbmfg.com 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:* ch...@wbmfg.com
> *Sent:* Thursday, July 14, 2016 5:34 PM
> *To:* af@afmug.com
> *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:* af@afmug.com
> *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,  wrote:
>
>> Tried both.  Areas.  Even single cells.
>>
>> *From:* Bill Prince 
>> *Sent:* Thursday, July 14, 2016 5:23 PM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT Excel arrgh
>>
>>
>> What if you just do a column or row?
>>
>> bp
>> 
>>
>>
>> On 7/14/2016 4:20 PM, ch...@wbmfg.com 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?
>>
>>
>>
>

Re: [AFMUG] Fw: OT Excel arrgh

[Bill Prince]

Ah. Quickbooks. When you export a report from Quickbooks, it fluffs it 
up something fierce.



bp
<part15sbs{at}gmail{dot}com>

On 7/14/2016 5:09 PM, Chuck McCown wrote:
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 <mailto:geo...@cbcast.com>
*Sent:* Thursday, July 14, 2016 5:52 PM
*To:* af@afmug.com <mailto:af@afmug.com>
*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, ch...@wbmfg.com 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:* ch...@wbmfg.com <mailto:ch...@wbmfg.com>
*Sent:* Thursday, July 14, 2016 5:34 PM
*To:* af@afmug.com <mailto:af@afmug.com>
*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:ahan...@gmail.com>
*Sent:* Thursday, July 14, 2016 5:30 PM
*To:* af@afmug.com <mailto:af@afmug.com>
*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, <ch...@wbmfg.com <mailto:ch...@wbmfg.com>> 
wrote:


Tried both.  Areas. Even single cells.
*From:* Bill Prince <mailto:part15...@gmail.com>
*Sent:* Thursday, July 14, 2016 5:23 PM
*To:* af@afmug.com <mailto:af@afmug.com>
*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, ch...@wbmfg.com <mailto:ch...@wbmfg.com> 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?

Re: [AFMUG] Fw: OT Excel arrgh

[Chuck McCown]

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: af@afmug.com 
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, ch...@wbmfg.com 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: ch...@wbmfg.com 
  Sent: Thursday, July 14, 2016 5:34 PM
  To: af@afmug.com 
  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: af@afmug.com 
  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, <ch...@wbmfg.com> wrote:

Tried both.  Areas.  Even single cells.  

From: Bill Prince 
Sent: Thursday, July 14, 2016 5:23 PM
To: af@afmug.com 
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, ch...@wbmfg.com 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?

Re: [AFMUG] Fw: OT Excel arrgh

[George Skorup]

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, ch...@wbmfg.com 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:* ch...@wbmfg.com 
*Sent:* Thursday, July 14, 2016 5:34 PM
*To:* af@afmug.com 
*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:* af@afmug.com 
*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, > wrote:

Tried both.  Areas.  Even single cells.
*From:* Bill Prince 
*Sent:* Thursday, July 14, 2016 5:23 PM
*To:* af@afmug.com 
*Subject:* Re: [AFMUG] OT Excel arrgh

What if you just do a column or row?

bp


On 7/14/2016 4:20 PM, ch...@wbmfg.com  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?

[AFMUG] Fw: OT Excel arrgh

[chuck]

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: ch...@wbmfg.com 
Sent: Thursday, July 14, 2016 5:34 PM
To: af@afmug.com 
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: af@afmug.com 
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,  wrote:

  Tried both.  Areas.  Even single cells.  

  From: Bill Prince 
  Sent: Thursday, July 14, 2016 5:23 PM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT Excel arrgh

  What if you just do a column or row?


bp


On 7/14/2016 4:20 PM, ch...@wbmfg.com 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?