Question about Computers & Internet

# How to convert numbers to text Example Rs.10000/- how to change it Ten Thousand

Posted by on

• Galen Tackett May 11, 2010

The question is so general that providing a specific answer would be very difficult. In what context do you need to convert numbers to text:

• A scripting or programming language, like C or C++, awk, python, etc? If so, which one(s)?

• A command shell? Which one?

• A specific application, like Microsoft Excel or Access?

• Some other context?

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Expert

Posted on Jan 06, 2009

## 1 Suggested Answer

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### What is a mixed number or in a fraction in simplest form 0.15%

A mixed number is a number composed of an integer (whole) number and a proper fraction, one that has a numerator less than the denominator. Example 2 1/3 =2+ 1/3. 2 is the integer part, and 1/3 is the proper fraction part.
Certain fractions can be simplified further because the numerator and denominator share a (common) factor. By cancelling the common factor in the numerator with the factor in the denominator,
one gets a fraction with smaller numerator and denominator.
For example the percentage you provide 0.15% can be converted to 15/10000.
Since 15 and 1000 are both multiples of 5, the number 5 is a common factor in both. 15=5*3, and 10000=5*2000
Cancel the two 5 (simplifying by 5) in numerator and denominator leaves 3/2000. Thus
0.15%= 0.15/100=0.0015=3/200
I hope that this makes sense to you.

Sep 04, 2014 | The Learning Company Achieve! Math &...

### I have overhualed my 1.8K series engine taken the crankshaft from std to .10000 now i need to buy cons and big end bearings. Can anyone help with part numbers for the same? Jun 06, 2014

Normally the crank grinder would supply shells?
Any engine refurb shop would know where to get bearings. Go online to a non franchised LR dealer and see what they know.

Jun 06, 2014 | 2002 Land Rover Freelander

### 10000+200000=

Follow the decimal places jovinregino. Two hundred thousand plus ten thousand = two hundred ten thousand. 210000. (210,000.00)

Jun 16, 2010 | Facebook Social Network

### Hi, I have an HP12C and for some reason the

Turn the calculator off. Hold down the period (decimal) key and hit the "ON" button at the same time.

Mar 03, 2010 | HP 12c Calculator

### In MS Excel, convert a Number in Text formate

Dear,

you've use macro to this.

Press Alt+F11
it will open Microsoft Vsual Basic Editor.

Click on Module in Insert Menu and paste the following codings:

Function ConvRs(ByVal MyNumber)
Dim Rupees, Paise, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Lac "
Place(4) = " Crore "
Place(5) = " Arab " ' String representation of amount
MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none
DecimalPlace = InStr(MyNumber, ".")
' Convert Paise and set MyNumber to Rupee amount
If DecimalPlace > 0 Then
Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber <> ""
If Count = 1 Then Temp = GetHundreds(Right(MyNumber, 3))
If Count > 1 Then Temp = GetHundreds(Right(MyNumber, 2))
If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees
If Count = 1 And Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
If Count > 1 And Len(MyNumber) > 2 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 2)
Else
MyNumber = ""
End If
End If
Count = Count + 1
Loop
Select Case Rupees
Case ""
Rupees = "No Rupees"
Case "One"
Rupees = "One Rupee"
Case Else

'Rupees = Rupees & " Rupees"
Rupees = "Rupees " & Rupees

End Select
Select Case Paise
Case ""

'Paise = ""
Paise = " Only"
Case "One"
Paise = " and One Paisa"
Case Else
Paise = " and " & Paise & " Paise"

End Select
ConvRs = Rupees & Paise
End Function
'***************************************...
' Converts a number from 100-999 into text *
'***************************************...
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3) 'Convert the hundreds place
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
'Convert the tens and ones place
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
'***************************************...
' Converts a number from 10 to 99 into text. *
'***************************************...
Function GetTens(TensText)
Dim Result As String
Result = "" 'null out the temporary function value
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit _
(Right(TensText, 1)) 'Retrieve ones place
End If
GetTens = Result
End Function
'***************************************...
' Converts a number from 1 to 9 into text. *
'***************************************...
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function

save this as as ConvertRs.xla in Microsoft\AddIns folder

now, you'll have to activate this AddIns:
in your Excel Worksheet select:
Check the ConvertRs option
now this will be used as User Defined Function.
you can insert it from the Function Options or just enter the following command in the desired cell where you want the result:

=ConvertRs(Cell Reference)

Cell Reference means where the number is available, you want to convert.

Try this and then tell me the responce.

Jul 09, 2009 | Microsoft Computers & Internet

### Need Formula

TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. \$
SQL Database Migration \$
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! \$
CSV Converter \$

IMPORTING
Import SQL Into Excel-SQL Tester \$
Import Excel Into Access \$

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

### CONVERSION OF NUMERICAL VALUE INTO TEXT IN M.S. EXCEL

to convert numbers into text, just add an apostrophe ' to the left of the number. When you press enter, the apostrophe will no appear, but the number will have the atrtibutes of text

Nov 18, 2008 | Microsoft Windows XP Home Edition

### Indian Rupee format in Excel spreadsheet

Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00

Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0

Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

Sep 14, 2008 | Microsoft Excel for PC

### How to convert my numirecal velue into text

There is no standard function for doing this in Access 2003, you will have to write a function yourself, or have someone do it for you.

Jun 28, 2008 | Microsoft Office Access 2003 (077-02871)...

## Open Questions:

#### Related Topics:

54 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert

Level 3 Expert