Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-29-2019, 09:56 AM
Strogg Strogg is offline How to get rid of Hyphens and spaces in result using dollartext switch Windows 7 32bit How to get rid of Hyphens and spaces in result using dollartext switch Office 2016
Novice
How to get rid of Hyphens and spaces in result using dollartext switch
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get rid of Hyphens and spaces in result using dollartext switch Field Code/Switch for Time not working Ozzie2842 Mail Merge 1 12-20-2016 01:08 PM
How to get rid of Hyphens and spaces in result using dollartext switch UpperCase to one colour hendrikbez Word 7 11-16-2016 12:35 AM
How to get rid of Hyphens and spaces in result using dollartext switch 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
How to get rid of Hyphens and spaces in result using dollartext switch Uppercase formula? clements55 Excel 1 08-20-2014 11:34 PM
How to get rid of Hyphens and spaces in result using dollartext switch Day and Month to Uppercase Andy2011 Word VBA 1 07-22-2011 04:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft