View Single Post
 
Old 01-29-2019, 09:56 AM
Strogg Strogg is offline Windows 7 32bit Office 2016
Novice
 
Join Date: Jan 2019
Posts: 9
Strogg is on a distinguished road
Default How to get rid of Hyphens and spaces in result using dollartext switch

Hi, experts


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 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 that:
TWENTYTHREETHOUSANDTWOHUNDREDFORTYFIVE AND 00/100


Is it possible?
Reply With Quote