Arrays to return a written text and numerical values

[Toby]

How do I put together an array that's going to give me a
Actual words and numerical that I've entered into a cell
instead of a numerical value of zero when I've entered in
words?

 

[Frank Kabel]

Hi Toby
maybe it's just me but I did not unterstand you. Can you give an
example?