Precision as displayed problems

S

sivatca

I am having problems with the "precision as displayed function" which is
important to be "on" for my excel files, is there any way to put it "on"
as default as opposed to it being "off" on opening a new excell file?

Also when excel files which are saved with precision as displayed "on"
are posted on a network, another user who opens them by moving or
copying a specific tab to his own file, gets all the files in his
workbook with precision "off", including the original one........is
there a way to stop this?

How can I ensure that precision is on at all times?

Thanks
 
B

Bernie Deitrick

Open a new workbook, then use Tools / options.... to set the precision as displayed.

Save the workbook as Book.xlt in your startup folder - it will be the basis of all new workbooks,
and the setting should carry over.

HTH,
Bernie
MS Excel MVP
 

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

ROUND or "Precision as displayed"? 2
How Excel to do calculations using more than 12 digits precision? 7
Selective Precision as Displayed 4
polynomial fit coefficients displayed to an arbitrary precision? 1
Format affects precision? 2
precision as displayed 2
Use displayed value, not stored value? 1
Precision as Displayed checked as default setting 3

Top