User Profile

Collapse

Profile Sidebar

Collapse
DaveBonallack
DaveBonallack
Last Activity: Mar 31 '21, 04:13 AM
Joined: Mar 30 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • DaveBonallack
    replied to How to replace number to Alphabet
    Hi SioSio,
    Do you mean putting numbers into words, like 1234 returns One Thousand Two hundred Thirty-Four?

    If so, then this monster formula I found online (apologies to the originator - I've lost your name) works well. No VBA.
    Paste it into Cell C3. It converts the digits you've entered in Cell B3 into words

    Regards - Dave.

    Code:
    =IF(OR(LEN(FLOOR(B3,1))>=13,FLOOR(B3,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B3),REPT(0,12)),1,1)+1,"","one
    ...
    See more | Go to post
    Last edited by Niheel; Mar 31 '21, 08:44 PM. Reason: added code tags

    Leave a comment:


  • Hi Fred.
    This can be done with a few lines of VBA, which need only be run once for each range you wanted to make static.
    Code that works through a predetermined range, cell by cell
    Code that removes conditional formatting from the cell
    Code that applies formatting in a 1-off way using the rules you set up in the original conditional formats
    Next cell in range.
    Are you familiar enough with VBA to do this?...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...