display a number in one cell as text in more than one cell?
"Storm" wrote:
Hi,
I need to be able to display a number eg. $18735.67 across mulitple cells
as text. I need the numbers to read as follows: ONE EIGHT SEVEN THREE
FIVE 67 where the spaces between each number denote separate columns and
the cents are displayed as numerical. Any help would be much appreciated.
Storm
|