How can I change a cell value to text
Closed
choculate
Posts
3
Registration date
Tuesday 16 March 2010
Status
Member
Last seen
16 March 2010
-
16 Mar 2010 à 03:30
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Mar 2010 à 08:40
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Mar 2010 à 08:40
Related:
- How can I change a cell value to text
- How to change computer name - Guide
- How to change lg tv name - Guide
- How to change idm language - Guide
- How to change language in kmplayer - Guide
- How to change email on facebook - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Mar 2010 à 10:12
16 Mar 2010 à 10:12
What you mean change into text ? You mean like in words ? or some thing else
choculate
Posts
3
Registration date
Tuesday 16 March 2010
Status
Member
Last seen
16 March 2010
16 Mar 2010 à 22:43
16 Mar 2010 à 22:43
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Mar 2010 à 09:46
17 Mar 2010 à 09:46
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Mar 2010 à 08:40
18 Mar 2010 à 08:40
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)
