Re: Array formulas won't recognize external data from Microsoft Qu

And you're selecting Paste special>Values+Multiply??? (Never known that fail)

Try a blank cell and Paste special>Value+Add

If this fails, try formatting as general first and repeat either route above. Also is this fails, sue helper columns, eg

=VALUE(A1)

and copy down and across and then copy>paste special... values and delete the old columns

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxx
www.nickhodge.co.uk


"mmrtech" <mmrtech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:89BC3E25-F6BB-4737-BAF2-CC1F3E428986@xxxxxxxxxxxxxxxx
I just tried that and I'm still seeing "1" as the result of the multiply paste.

"Nick Hodge" wrote:

Try putting the 1 on a ne *** or workbook before copying, so you know what
you copy is a number

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxx
www.nickhodge.co.uk


"mmrtech" <mmrtech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE6D497A-E943-4B91-A761-D893DAC4E284@xxxxxxxxxxxxxxxx
> Thanks for the reply, Nick. I looked up the value functions in my > Oracle
> SQL
> guide, but couldn't figure out how to get them to work here. I next > tried
> the
> copy/paste with multiplication, but the resulting value was 1. It's > like
> Excel is not even treating the data as numeric.
>
> Any other suggestions?
>
>
>
> "Nick Hodge" wrote:
>
>> External data, depending on it's source, quite often comes in as data,
>> try
>> either setting the data in MSQuery if you database accepts something >> like
>> the Val or Value functions, or copy a 1 and select your imported data >> and
>> Edit>Paste special...Values and multiply should 'force then to be seen >> as
>> numbers
>>
>> -- >> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxx
>> www.nickhodge.co.uk
>>
>>
>> "mmrtech" <mmrtech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:AFFB58A6-B350-4226-8CC0-B2BAA4348154@xxxxxxxxxxxxxxxx
>> >I set up an external query to pull data from an Oracle database into >> >a
>> >***
>> > in my excel file. I have array formulas on another *** that use >> > the
>> > external data as their data source for calculations. The problem is
>> > that
>> > all
>> > of the array formula results are zero.
>> >
>> > I found that if I re-type the data in external data cells, the data >> > is
>> > recognized and my array formula sums increase accordingly. I think
>> > there
>> > is
>> > some kind of hidden formatting on the external data, but can't find >> > it.
>> > Please help.
>> >
>> > Thanks.
>> >
>>


.