Hi, experts
For instance I have a table with number 23,245.00 in cell C1
Using field switch Dollartext I write the below code outside the table (of course bookmarking the table first):
{=SUM(TABLE1 C1) \* DOLLARTEXT \* UPPER}
...and pressing F9 have an output:
TWENTY-FOUR THOUSAND TWO HUNDRED FORTY-FIVE AND 00/100
But I would like to see it without hyphens and spaces in uppercase like below:
TWENTYTHREETHOUSANDTWOHUNDREDFORTYFIVE AND 00/100
Is it possible?
Bookmarks