Is anyone aware of a Pick function or third party software that can
translate the Excel "exponential format" to Pick-readable data?

We are importing data from Excel and this formatting is of course
giving us fits.

Any and all assistance is greatly appreciated.

Regards,
RG

what does the raw data in the cell look like?

Most versions of Pick support either var ** power or var ^ power or the old
POWER(var,power)

Mark

"Skippy" <roger.grosser (AT) gmail (DOT) com> wrote

Even easier when the var == 10.

--
frosty

Mark Brown wrote:

Why You don't use cell NumberFormat before export?

Regards,
Grigory

On Feb 21, 2:13 pm, "Mark Brown" <mbr... (AT) drexelmgt (DOT) com> wrote:
The data in the cell is .096250, but when imported to Pick looks like
9.62500000000002E-02.

Then, for the sake of data transfer, I'd suggest changing the format of the
column to either text or to a number with specific number of decimal points.
The "real" data appears to be floating point.

On the Pick side, once the data is there, you could use a subroutine like
this:

sub convert.e(nmbr)
factor = field(nmbr,'E',2)
nmbr = field(nmbr,'E',1)
arg = 1:str(0,abs(factor))
if factor < 0 then nmbr = nmbr/(10*factor) else nmbr = nmbr * 10 * factor
return

Mark

"Skippy" <roger.grosser (AT) gmail (DOT) com> wrote