How can I change a cell value to text
Closed
choculate
Posts
3
Registration date
Tuesday March 16, 2010
Status
Member
Last seen
March 16, 2010
-
Mar 16, 2010 at 03:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2010 at 08:40 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2010 at 08:40 AM
Related:
- How can I change a cell value to text
- How to change free fire facebook account to google account - Guide
- How to change language in kmplayer - Guide
- Change computer name cmd - Guide
- How to change dinosaur in chrome - Guide
- How to change time in whatsapp - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 16, 2010 at 10:12 AM
Mar 16, 2010 at 10:12 AM
What you mean change into text ? You mean like in words ? or some thing else
choculate
Posts
3
Registration date
Tuesday March 16, 2010
Status
Member
Last seen
March 16, 2010
Mar 16, 2010 at 10:43 PM
Mar 16, 2010 at 10:43 PM
Yes bro, like e.g: as I said in D2 there is an amount of 50, but when I fill the cell B2 with the same amount (50) then the amount (50) in cell D2 should change to like (OK).
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 17, 2010 at 09:46 AM
Mar 17, 2010 at 09:46 AM
Download and install this add on
https://download.cnet.com/Morefunc/3000-2077_4-10423159.html
It got a function called TBTEXT, that you can use to covert numbers to words (like 50 to Fifty)
How D2 is being populated in the first place. ?
You may have to use
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
in the sheet where these values are.
https://download.cnet.com/Morefunc/3000-2077_4-10423159.html
It got a function called TBTEXT, that you can use to covert numbers to words (like 50 to Fifty)
How D2 is being populated in the first place. ?
You may have to use
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
in the sheet where these values are.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 18, 2010 at 08:40 AM
Mar 18, 2010 at 08:40 AM
It is not in setup. It is a function that is added to excel
So if 50 is in A1 and you want it to spell it out in B1 then in B1 you will write
=NBTEXT(A1)
So if 50 is in A1 and you want it to spell it out in B1 then in B1 you will write
=NBTEXT(A1)
