large number calculations in excel

  gizzyx 07:48 11 Feb 2003

when doing a spreadsheet using very large currency figures (over ten trillion pounds!!!), excel does not calculate exactly. it seems to round off. does anyone know how to force it to give exact calculations?

  VoG™ 09:26 11 Feb 2003

There is a limit to the number of significant figures that Excel can hold. I ca'nt remember what it is offhand. This is probably why you are getting rounding errors.

  BrianW 11:17 11 Feb 2003

further to VoG's observation you may be able to get round the rounding error problem by formatting the column(s) into "Scientific Notation" which will enable you to use more signicant numbers, raised to the necessary power (13 for 10s of trillions if I remember correctly). You would not be able to display the currency format in the column but would get round that by labelling your column with the relevant currency header).

  Ben Avery (Work) 11:30 11 Feb 2003


  jazzypop 11:34 11 Feb 2003

Excel has a nunber precision limit of 15 figures, according to it's help file.

  pj123 16:49 11 Feb 2003

I bet he wishes it was. And I did lol.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?