![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Ozzie2842 | Mail Merge | 1 | 12-20-2016 01:08 PM |
![]() |
hendrikbez | Word | 7 | 11-16-2016 12:35 AM |
![]() |
becca | Mail Merge | 2 | 06-08-2016 01:15 PM |
![]() |
clements55 | Excel | 1 | 08-20-2014 11:34 PM |
![]() |
Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |