The author of the Spreadsheet::WriteExcel module appears to have had a similar problem.

Spreadsheet::WriteExcel will work on the majority of Windows, UNIX and Macintosh platforms. Specifically, the module will work on any system where perl packs floats in the 64 bit IEEE format. The float must also be in little-endian format but it will be reversed if necessary. Thus:

 
print join(" ", map { sprintf "%#02x", $_ } 
      unpack("C*", pack "d", 1.2345)), "\n";

should give (or in reverse order): 

    0x8d 0x97 0x6e 0x12 0x83 0xc0 0xf3 0x3f
So, as I read it, if you aren't concerned about portability, the following should work:
my $dfloat=unpack("d",reverse($yourbigendian));
(remove the reverse bit if your box is big-endian. I'm assuming it's not, since you mentioned ActiveState..)

Update: Seems I was a bit confused about what format he did have the numbers in. ( In my defense, I'm still not clear :) Perhaps a pointer to the IEEE double format would make this node somewhat useful ? See This page from Sun


In reply to Re: 52-bit numbers as floating point by kschwab
in thread 52-bit numbers as floating point by John M. Dlugosz

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.