Question about Operating Systems

1 Answer

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?


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 66 Answers

Email me @ formore info.

Posted on Jan 06, 2009

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

How to convert a binary to text

Letters can be converted into decimal number using ASCII table. Every Character has it own equivalent number. Once converted into decimal (base 10), I could be easily converted into binary (base 2)
You could also use applications or web based applications such as ASCII to binary converter to help you convert it.

Jul 22, 2011 | Operating Systems

1 Answer

Hi, I am trying to change an excel spreadsheet. There are unit numbers on the spreadsheet which have converted themseles to dates ie 4/52 has now become Apr-52. I have tried everythiong to change it but...

Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.

Dec 22, 2010 | Microsoft Operating Systems

1 Answer

I have a lock on my apple ipod. It's on the welcome screen.It need 4 numbers.Can i get a solve for this immediately.Model-a1136 serial num- 9c7169jvv9k emc 2065

Your iPod is "locked". Enter the correct 4 digits, to unlock it.

Keep trying -- from 0-0-0-0 to 9-9-9-9 is only ten thousand different combinations. Statistically-speaking, you'll only need to make FIVE thousand attempts, on the average, to find the correct value.

Sep 12, 2010 | Operating Systems

1 Answer

Convert numbers to text in excell

  1. Start Microsoft Excel.
  2. Press ALT+F11 to start the Visual Basic Editor.
  3. On the Insert menu, click Module.
  4. Type the following code into the module sheet. Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert cents and set MyNumber to dollar amount. If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" Temp = GetHundreds(Right(MyNumber, 3)) If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars If Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop Select Case Dollars Case "" Dollars = "No Dollars" Case "One" Dollars = "One Dollar" Case Else Dollars = Dollars & " Dollars" End Select Select Case Cents Case "" Cents = " and No Cents" Case "One" Cents = " and One Cent" Case Else Cents = " and " & Cents & " Cents" End Select SpellNumber = Dollars & Cents 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
uparrow.gifBack to the top How to use the SpellNumber sample function loadTOCNode(2, 'moreinformation'); To use the sample functions to change a number to written text, use one of the methods demonstrated in the following examples: uparrow.gifBack to the top Method 1: Direct Entry loadTOCNode(2, 'moreinformation'); You can change 32.50 into "Thirty Two Dollars and Fifty Cents" by entering the following formula into a cell: =SpellNumber(32.50) uparrow.gifBack to the top Method 2: Cell reference loadTOCNode(2, 'moreinformation'); You can refer to other cells in the workbook. For example, enter the number 32.50 into cell A1, and type the following formula into another cell: =SpellNumber(A1) uparrow.gifBack to the top Method 3: Paste Function or Insert Function loadTOCNode(2, 'moreinformation'); To enter a custom function into a worksheet, you can use Paste Function in Excel 2000, or you can use Insert Function in Excel 2002 and in Excel 2003. Excel 2000 loadTOCNode(3, 'moreinformation'); To use Paste Function, follow these steps:
  1. Select the cell that you want.
  2. Click Paste Function on the Standard toolbar.
  3. Under Function category, click User Defined.
  4. Under Function name, click SpellNumber, and then click OK.
  5. Enter the number or cell reference that you want, and then click OK.
Excel 2002 and Excel 2003 loadTOCNode(3, 'moreinformation'); To use Insert Function, follow these steps:
  1. Select the cell that you want.
  2. Click Insert Function on the Standard toolbar.
  3. Under Or select a category, click User Defined.
  4. In the Select a function list, click SpellNumber, and then click OK.
  5. Enter the number or cell reference that you want, and then click OK.

Apr 01, 2010 | Microsoft Windows XP Professional

1 Answer

Program for calculator using vc++

hi, here the code...
class is used for items(item.h) . In this class are stored the two number into property and the result:
property double nr1;
property double nr2;

The operations like :asin,cos,power,pi,plu,divide,sqrt etc. are edited into inherited class from items:

#pragma once
#include "Items.h"

using namespace System;
public ref class asinus : public Items



double^ asin(double a)
return Math::Asin(a);



In the base class 6 boolean variable is used for the precedent operation:

bool plus;
bool minus;
bool produs;
bool divide;
bool sin;
bool prec;
For button equal:

private: System::Void btnegal_Click(System::Object^ sender, System::EventArgs^ e)
prec = false;

if(plus == true)
this->txtRes->Text = Convert::ToString(p.aduna(i.nr1,i.nr2));
else if(minus == true)
this->txtRes->Text = Convert::ToString(m.scadere(i.nr1,i.nr2));
else if(produs == true)
this->txtRes->Text = Convert::ToString(pr.inmultire(i.nr1,i.nr2));
else if(divide == true)
this->txtRes->Text = Convert::ToString(d.impartire(i.nr1,i.nr2));

there is a function for operaton click:
private: System::Void Operation_Click(System::Object^ sender, System::EventArgs^ e) { if(prec == false) { i.nr1 = Convert::ToDouble(this->txtRes->Text); } if(prec == true) { i.nr2 = Convert::ToDouble(this->txtRes->Text); } }

Apr 10, 2009 | Microsoft Operating Systems

1 Answer

Need Formula

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

Select Case Statement. Great alternative to Else If Statements

VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
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 $

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

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

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

2 Answers

Vb variable error

Change the code:

strdbname = "d:\vivek\company.mdb"
Set DB = DBEngine.OpenDatabase("D:\VIVEK\COMPANY.MDB")
strrsname = "company"
Set RS = DB.OpenRecordset("COMPANY")
comp.Text = RS!COM_CODE
compnm.Text = RS!COMPANY
isinno.Text = RS!ISIN
AD1.Text = RS!ADD1
'AD2.Text = RS!ADD2
'AD3.Text = RS!ADD3
AD4.Text = RS!ADD4
'PG.Text = RS!Page
to become:

strdbname = "d:\vivek\company.mdb"
Set DB = DBEngine.OpenDatabase(strdbname )
strrsname = "company"
Set RS = DB.OpenRecordset(strrsname )
comp.Text = RS!COM_CODE
compnm.Text = RS!COMPANY
isinno.Text = RS!ISIN
AD1.Text = RS!ADD1
AD2.Text = RS!ADD2
AD3.Text = RS!ADD3
AD4.Text = RS!ADD4
PG.Text = RS!Page
mostly to eliminate the extra "quote" (') characters,
and to use the values you set.

Dec 10, 2008 | Operating Systems

3 Answers


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

1 Answer

Vb6 source code is not compiling.

What the heck are you compiling it with that doesn't give a line number for that error? Pay attention to the titles of messageboxes! Perhaps noting what lines you changed from the original will give a clue to narrow it down, but I expect you addressed an object with a property ( in a context that can't be expected to generate or use that property as you gave it. Moreover there are spaces in object names, it seems....

Apr 13, 2008 | Operating Systems

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

52 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides