Re: [AFMUG] Fw: OT Excel arrgh

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

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 wrote: > You would think! I really wish text to numbers was a right click operation > and not like

Re: [AFMUG] Fw: OT Excel arrgh

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?

Re: [AFMUG] Fw: OT Excel arrgh

kbooks. 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 C

Re: [AFMUG] Fw: OT Excel arrgh

@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

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

[AFMUG] Fw: OT Excel arrgh

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,