Thanks Don. I'm using a new laptop and did not set precision display
in advanced options.
Thx.
> Round where desired.
>
[quoted text clipped - 3 lines]
> SalesAid Software
> dguille...@austin.rr.com<ArgarLar...@gmail.com> wrote in message
Don did not suggest Set Precision as Displayed but rather the use of the
ROUND function. Many people have warned of the dangers of using the Set
Precision method since it applies to all open workbooks. But if you have
just a single use of Excel you should be OK
best wishes

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> Thanks Don. I'm using a new laptop and did not set precision display
> in advanced options.
[quoted text clipped - 8 lines]
>> SalesAid Software
>> dguille...@austin.rr.com<ArgarLar...@gmail.com> wrote in message
Niek Otten - 07 Nov 2007 13:42 GMT
< it applies to all open workbooks.>
I don't think that is the case, Bernard
I have two workbooks open in Excel. I click Exit in the File menu. Excel asks if it should save changes for both workbooks.
I assume that means they are open in the same instance of Excel.
Still checking precision as displayed in one of the workbooks has no effect on the other

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Don did not suggest Set Precision as Displayed but rather the use of the
| ROUND function. Many people have warned of the dangers of using the Set
[quoted text clipped - 13 lines]
| >> SalesAid Software
| >> dguille...@austin.rr.com<ArgarLar...@gmail.com> wrote in message