Precision as displayed

S

Susan Lambert

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.
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selective Precision as Displayed 4
ROUND or "Precision as displayed"? 2
Format affects precision? 2
Format query result as Data Type Number, Field Size Decimal 3
Precision as displayed problems 1
Linked DB2 Tables and "Decimal field's precision is too small to..." Error 2
Precision in formulas? 4
counting decimal places 8

Top