Services & Resources / Wolfram Forums
MathGroup Archive
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Re: precission/accuracy in mathlink for excel

  • To: mathgroup at
  • Subject: [mg53378] Re: [mg53356] Re: precission/accuracy in mathlink for excel
  • From: Peter Lizak <plizak at>
  • Date: Sat, 8 Jan 2005 23:02:38 -0500 (EST)
  • References: <crknom$9fo$> <>
  • Reply-to: Peter Lizak <plizak at>
  • Sender: owner-wri-mathgroup at

Nopt, not that.

Needed to set $ExcelPrecision.
I just upped it to 10.

On Sat, 8 Jan 2005 02:39:23 -0500 (EST), nafod40 <noneya at> wrote:
> plizak wrote:
> > I have some code running in a spreadsheet on a M-code worksheet in
> > excel.
> >
> > I can call the code in either a VBA macro or in a cell, but it only
> > returns four digits of accuracy.  Yet when I run it in a notebook in
> > Mathematica I get more precision.
> >
> > Is there a way to get more precision?
> Double check the settings in Excel under the Format-Cell dialog box to
> see if you aren't truncating the precision there.
> I use the mathlink, and get full precision coming across.

  • Prev by Date: easy question about random numbers
  • Next by Date: Re: Export Animation
  • Previous by thread: Re: precission/accuracy in mathlink for excel
  • Next by thread: Evaluation of NSum arguments