How can I change a cell value to text

Closed
Report
Posts
3
Registration date
Tuesday March 16, 2010
Status
Member
Last seen
March 16, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello All,

Actually I have a problem: eg: there is a figure/amount in cell D2 and I want that when I fill the cell B2 by the same figure/amount then the figure/amount in the cell D2 should change into a text.

I hope any of you guyz can help me with this problem, Thanks in advance.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What you mean change into text ? You mean like in words ? or some thing else
0
Posts
3
Registration date
Tuesday March 16, 2010
Status
Member
Last seen
March 16, 2010

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).
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.
0
Bro tnx for showing your interest to help me. but to be honest I am not that good in excell and even couldn't find the function TBText in the setup I installed. so plz plz instruct me abit simple like am a excel biggner.

Thanks
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)
0