+ Reply to Thread
Results 1 to 5 of 5

No Hyphens and spaces in result when using dollartext switch

  1. #1
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    No Hyphens and spaces in result when using dollartext switch

    Hi, experts

    For instance 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 pressing F9 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 below:
    TWENTYTHREETHOUSANDTWOHUNDREDFORTYFIVE AND 00/100

    Is it possible?

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: No Hyphens and spaces in result when using dollartext switch

    Not possible.

    Cross-posted at: http://www.msofficeforums.com/word/4...ult-using.html
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    Re: No Hyphens and spaces in result when using dollartext switch

    Quote Originally Posted by macropod View Post
    Not possible.

    Cross-posted at: http://www.msofficeforums.com/word/4...ult-using.html
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Sorry for that. From now on I will link cross-posts.

    As a workaround I used condensed space. Looks a bit ugly.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: No Hyphens and spaces in result when using dollartext switch

    Do be aware than anything you do to the field result will be undone as soon as anything causes the field to refresh.

  5. #5
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    Re: No Hyphens and spaces in result when using dollartext switch

    But, format is kept even after refresh.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Partial search to disregard spaces and hyphens
    By mcpearson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-21-2015, 08:21 PM
  2. Using Countif between values with hyphens and values without hyphens
    By MetroBOS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2014, 12:37 AM
  3. [SOLVED] Formula that Transforms Cell Column into Lower Case and replaces spaces with hyphens
    By diemking in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2013, 12:50 AM
  4. [SOLVED] Remove Spaces and Hyphens in a Tet String
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2013, 06:02 PM
  5. delete spaces, hyphens and then duplicates
    By versatility in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-12-2010, 12:37 PM
  6. Replies: 12
    Last Post: 09-06-2005, 04:05 AM
  7. Does XL2K have "hard hyphens" (non-break hyphens)?
    By StargateFan in forum Excel General
    Replies: 0
    Last Post: 01-29-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1