Leith Ross wrote:

Hello ZBC2,

For example using cell A6 for the result, the formula would be...

=TEXT(A5, Len(A5))

Sincerely,
Leith Ross




I just realized that it still shows up as an equation in cell A6 ...
I guess I want to permanently replace A6 with it's contents ??? and not
show up as an equation ???