#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Not possible.
Cross-posted at: https://www.excelforum.com/word-form...xt-switch.html For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |