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

Selective Precision as Displayed 4
Descenders clipped 0
How Excel to do calculations using more than 12 digits precision? 7
ROUND or "Precision as displayed"? 2
Shortcuts in OneDrive 0
precision as displayed doesn't always work 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top