If I use the copy feature to copy your XL2BB dispaly to my worksheet, [... then ...] if I widen my columns and format B10 as percentage with 13 decimal places I see this. Isn't that what you are saying cannot be shown with XL2BB?

Yes. And in your description, it is

__Excel__, not XL2BB, that is showing B10 to 13 dp. QED.

Be that as it may, the steps that you describe might be a suitable work-around,

__as long as__ the XL2BB excerpt in the user's posting includes all referenced cells.

If my XL2BB excerpt had contained only row 10, your work-around would not work.

For example, try to display B10 to 13 dp based on the following excerpt.

We have no control over what users include in their XL2BB excerpt. In fact, users might use XL2BB instead of a link to an Excel file for the very reason that they do not want to include all of the referenced cells, or they cannot because it is simply too much to include in a posting.

-----

BTW, when I copy the XL2BB excerpt in my original posting (and the one above), then paste into Excel, I get a #VALUE error in B10.

That is because B10 is not pasted as a array-entered formula.

I think that is a limitation of the copy-and-paste clipboard mechanism, not something that XL2BB can control.

But it makes the work-around less "straight-forward". I must array-enter the formula manually.

Fortunately, my example has only one array-entered formula. Imagine the difficulty if the user's XL2BB excerpt has many more.

Moreover, the corrected formula will not have the same result, because the referenced cells are empty.

-----

Bottom line: I think my issue is still valid: it would be nice if XL2BB

*per se* included a mechanism for seeing the full precision of formulas, just as it does for constants.

Consider the following example.

(Aside: If you use the XL2BB copy feature, D8 will display 1 instead of #N/A. So the result of the XL2BB copy feature does not always reproduce the problem. B8 is the result of copy-and-paste-value of the result of a formula. C8 is a constant that was entered manually.)

Even though B8 displays 6.09%, we can see the full precision (up to 15 significant digits) by hovering the cursor over the XL2BB cell.

Apparently, that is because the raw XL2BB text contains the field ``XD=v:m|fz:10pt|cls:ww|

tx:6.08512345123451E-02`` surrounded by square brackets.

I think I am asking that a similar field be added to the raw XL2BB text for cells with

__formulas__, as well.

(Errata: Maybe not. Not sure how hovering the cursor over the cell would show both the formula and the exact value ("tx" field). "The details are left to the student" (wink).)

-----

However, even 15 significant digits is not sufficient to represent the exact binary value. And sometimes, we need the exact binary value in order to explain anomalous Excel results.

So I wonder if the "tx" presentation can be embellish to show constant and formula cell values in the following form (using B8 as an example):

tx:6.08512345123451E-02

- 4.86E-17
Ideally, avoid the factor at the end if it is 0.00E+0, which is exact zero. Thus, the "tx" presentation will look "normal" for most constants.

This can be created with the following VBA expression:

Code:

```
Replace(Replace(Format(Range("b8"), "0.00000000000000E+0") & _
" + " & Format(Range("b8") - Format(Range("b8"), "0.00000000000000E+0"), "0.00E+0"), "+ -", "- "), _
" + 0.00E+0", "")
```

(That is 14 zeros after "0.". That format converts all values to 15 significant digits, regardless of magnitude.)

For C8, we see just tx:6.08512345123451E-02.

The difference of -4.86E-17 is necessary to explain why MATCH returns #N/A in D8.