![]() |
|
#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? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Field Code/Switch for Time not working
|
Ozzie2842 | Mail Merge | 1 | 12-20-2016 01:08 PM |
UpperCase to one colour
|
hendrikbez | Word | 7 | 11-16-2016 12:35 AM |
how to format a picture switch in a merge field to only include the numbers in the middle?
|
becca | Mail Merge | 2 | 06-08-2016 01:15 PM |
Uppercase formula?
|
clements55 | Excel | 1 | 08-20-2014 11:34 PM |
Day and Month to Uppercase
|
Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |