PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Precision as displayed

Reply

Precision as displayed

 
Thread Tools Rate Thread
Old 17-12-2004, 04:47 PM   #1
Susan Lambert
Guest
 
Posts: n/a
Default Precision as displayed


Which is better to use: internal precision or precision as displayed. Some
of our spreadsheets go out to 4-5 decimal places. We get spreadsheets from
our members also which may or may not have this setting enabled. We're
trying to figure out which is best and leave it at that.


  Reply With Quote
Old 17-12-2004, 07:36 PM   #2
Harald Staff
Guest
 
Posts: n/a
Default Re: Precision as displayed

Hi

Internal precision is the best. One thing is to display that 1/3 equals 0.33
, another thing is to pretend that it is.

HTH. Best wishes Harald

"Susan Lambert" <slambert@ironcasting.org> skrev i melding
news:eUTTpgF5EHA.2580@TK2MSFTNGP10.phx.gbl...
> Which is better to use: internal precision or precision as displayed.

Some
> of our spreadsheets go out to 4-5 decimal places. We get spreadsheets

from
> our members also which may or may not have this setting enabled. We're
> trying to figure out which is best and leave it at that.
>
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off