Messages In This Digest (2 Messages)

Messages

1a.: Re: Need help 'cause of changes to what MSN returns

Posted by: "Ryalmokas" ryalmokas@hotmail.com Ryalmokas

Sun Apr 8, 2012 5:58 am (PDT)

Thanks Randy. As always you're 3 steps ahead of me.
Happy Easter,
Dick

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I added " Bill" and " Mill" suffix conversions to the add-in. This beta
> version can be found in the "Works in Progress" folder of the files area,
> within RCH_Stock_Market_Functions-2.1.2012.04.07.zip.
>
> Best practice is to exit EXCEL before updating add-in files.
>
> On Sat, Apr 7, 2012 at 6:36 PM, Ryalmokas <ryalmokas@...> wrote:
>
> > I use Excel 2007, although as you'll see from my question I'm not an
> > advanced user. Today I decided to use one of my earlier financial
> > workbooks, and one of the data elements I have been using comes from;
> > rchgetelementnumber (symbol, 302).
> >
> > For a stock like IBM it would return $87,100,000,000; now it returns
> > $87.1 Bill, and my workbook chokes because of other formulae depending on
> > the currency format rather than $87.1 Bill. Somewhere along the line MSN
> > changed how it reports some fields.
> >
> > Is there a way to take the $87.1 Bill and transform it to either a
> > numeric 87.1 or to currency of $87,100,000,000?
> >
> > Thanks for any help offered,
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)