#1   Report Post  
Old December 17th 04, 04:47 PM
Susan Lambert
 
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.



  #2   Report Post  
Old December 17th 04, 07:36 PM
Harald Staff
 
Posts: n/a
Default

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" skrev i melding
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 06:11 AM
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 3 January 11th 05 08:28 PM
graph displayed in ascending order of value? [email protected] Charts and Charting in Excel 3 January 7th 05 04:21 AM
changed fonts are not displayed tim Excel Discussion (Misc queries) 1 December 28th 04 08:53 PM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 10:39 PM


All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017