Convert numbers into english text

[neha]

i want indian rupees written in numbers(figures) to be converted in to english(india) text/ words
please help me know the function for this ( eg in excel the function is spellnumber() or spellcur())

[mariosv]

There is an extension.

https://extensions.libreoffice.org/extensions/numbertext-1

[mikekaganski]

There’s no spellnumber function in Excel, only macros that are available on Internet using search.

You may use the answer accepted here.

[OregonJohn]

Create a macro. For each number replace with text. Select a range of cells to run the macro on, then run the macro.

From OpenOffice forum thread
Loop through a selected range of cells and

Sub Learn2
Dim myController as Object, myRange as Object
Dim newRange(0, 0)
Dim Tmp as Integer
Dim i, j, col, row

myController = ThisComponent.getCurrentController()
myRange = myController.getSelection().getDataArray()
Redim newRange(UBound(myRange, 1), UBound(myRange(0), 1))
row = 0
col = 0
For row = 0 to UBound(myRange, 1)
    For col = 0 to UBound(myRange(0), 1)
        newRange(row, col) = myRange(row)(col) * 2
    Next col
Next row
myController.getSelection().setDataArray(newRange)

End Sub

Look for the line

newRange(row, col) = myRange(row)(col) * 2

That is where you would put your replacement values.

Look at libreoffice.org … if…then…else to create the replacement values.

Just off the top of my head (probably wrong code though)

If newRange(row, col) = 1 then newRange(row, col) = "some kind of text"
If newRange(row, col) = 2 then newRange(row, col) = "otherkind of text"

Hope this helps. John.