Assume "2" is stored as string how to convert to numeric 2

Ad

Hi Saiprasad, Tough day huh?! :-) Try the following: Suppose "2" is in cell "A1" Type: =value(a1). Let me know if this helped and please rate my solution. Best, D.

Posted on Sep 03, 2007

Ad

to convert from text to binary, you would do something along the following lines..

1. have the user enter a string.

2. loop through the string (for each char in stringEntered..)

3. convert the character to binary using the methods provided to you by your language of choice

For the reverse (binary to text):

you must take 8 bits of data (which would be a single character), and convert it to text using the methods provided by your language of choice..

here's some links that might be of interest to you.

Visual FoxPro VFP CTOBIN and BINTOC Functions Equivalent In Net The Most Accurate and Reliable Source Code Converters

1. have the user enter a string.

2. loop through the string (for each char in stringEntered..)

3. convert the character to binary using the methods provided to you by your language of choice

For the reverse (binary to text):

you must take 8 bits of data (which would be a single character), and convert it to text using the methods provided by your language of choice..

here's some links that might be of interest to you.

Visual FoxPro VFP CTOBIN and BINTOC Functions Equivalent In Net The Most Accurate and Reliable Source Code Converters

Feb 06, 2015 | Microsoft Visual Studio 6 6.0 Professional...

The calculator does have several error message concerning the argument. For the Request( command the syntax is

Request(Message, VarName)

What you type is stored as a string. It is only after you try to convert it to a value that the calculator looks at its content.

Here is an example where the variable VarName is x

Request ("Variable x", x)

I enter a complex number, manipulate it mildly with no apparent problem. However when I try to convert it to a numerical expression, and store it in the variable x, y, theta, I get a message Error non-real result.

Request(Message, VarName)

What you type is stored as a string. It is only after you try to convert it to a value that the calculator looks at its content.

Here is an example where the variable VarName is x

Request ("Variable x", x)

I enter a complex number, manipulate it mildly with no apparent problem. However when I try to convert it to a numerical expression, and store it in the variable x, y, theta, I get a message Error non-real result.

Jan 13, 2014 | Texas Instruments Voyage 200 Calculator

Access control is implemented using

A) Cache

B) Firewall

C) Hyperlinks

D) JSP

A) Cache

B) Firewall

C) Hyperlinks

D) JSP

Jan 10, 2011 | Computers & Internet

Hi,

You could use a combination of the CONVERT and CAST functions to cast the number as a money type, then convert it to a varchar, and then strip off the decimal point and 2 0's at the end: DECLARE @test int SELECT @test = 12345 SELECT REPLACE(CONVERT(varchar(50), CAST(@test AS money), 1),'.00','')

Regards, ploysandy

You could use a combination of the CONVERT and CAST functions to cast the number as a money type, then convert it to a varchar, and then strip off the decimal point and 2 0's at the end: DECLARE @test int SELECT @test = 12345 SELECT REPLACE(CONVERT(varchar(50), CAST(@test AS money), 1),'.00','')

Regards, ploysandy

Jun 26, 2010 | Computers & Internet

Here is a very popular bit of code **from Microsoft**
that will
convert any currency amount in a cell to English words. **All code and
text from
below here is the work of Microsoft.**

**Summary**

This article shows you how to create a sample, user-defined function named ConvertCurrencyToEnglish() to convert a numeric value to an English word representation. For example, the function will return the following words for the number 1234.56:**One Thousand
Two Hundred
Thirty Four Dollars And Fifty Six Cents**

The Function Wizard can also be used to enter a custom function in a worksheet. To use the Function Wizard, follow these steps:

1. Click the Function Wizard button, and select User Defined under Function Category.

2. Select ConvertCurrencyToEnglish, and enter your number or cell reference.

3. Click Finish

**To Create the Sample Functions**

1. Insert a module sheet into a workbook. To do this in Microsoft Excel 97 or Microsoft Excel 98, point to Macro on the Tools menu, and then click Visual Basic Editor. In the Visual Basic Editor, click Module on the Insert menu. In Microsoft Excel 5.0 or 7.0, point to Macro on the Insert menu and click Module.

2. Type the following code into the module sheet.

**Function ConvertCurrencyToEnglish (ByVal MyNumber)**

Dim Temp

Dim Dollars, Cents

Dim DecimalPlace, Count

ReDim Place(9) As String

Place(2) = " Thousand "

Place(3) = " Million "

Place(4) = " Billion "

Place(5) = " Trillion "

' Convert MyNumber to a string, trimming extra spaces.

MyNumber = Trim(Str(MyNumber))

' Find decimal place.

DecimalPlace = InStr(MyNumber, ".")

' If we find decimal place...

If DecimalPlace > 0 Then

' Convert cents

Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)

Cents = ConvertTens(Temp)

' Strip off cents from remainder to convert.

MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

End If

Count = 1

Do While MyNumber <> ""

' Convert last 3 digits of MyNumber to English dollars.

Temp = ConvertHundreds(Right(MyNumber, 3))

If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

If Len(MyNumber) > 3 Then

' Remove last 3 converted digits from MyNumber.

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop

' Clean up dollars.

Select Case Dollars

Case ""

Dollars = "No Dollars"

Case "One"

Dollars = "One Dollar"

Case Else

Dollars = Dollars & " Dollars"

End Select

' Clean up cents.

Select Case Cents

Case ""

Cents = " And No Cents"

Case "One"

Cents = " And One Cent"

Case Else

Cents = " And " & Cents & " Cents"

End Select

ConvertCurrencyToEnglish = Dollars & Cents

**End Function**

**Private Function ConvertHundreds (ByVal MyNumber)**

Dim Result As String

' Exit if there is nothing to convert.

If Val(MyNumber) = 0 Then Exit Function

' Append leading zeros to number.

MyNumber = Right("000" & MyNumber, 3)

' Do we have a hundreds place digit to convert?

If Left(MyNumber, 1) <> "0" Then

Result = ConvertDigit(Left(MyNumber, 1)) & " Hundred "

End If

' Do we have a tens place digit to convert?

If Mid(MyNumber, 2, 1) <> "0" Then

Result = Result & ConvertTens(Mid(MyNumber, 2))

Else

' If not, then convert the ones place digit.

Result = Result & ConvertDigit(Mid(MyNumber, 3))

End If

ConvertHundreds = Trim(Result)

**End Function**

**Private Function ConvertTens (ByVal MyTens)**

Dim Result As String

' Is value between 10 and 19?

If Val(Left(MyTens, 1)) = 1 Then

Select Case Val(MyTens)

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

' .. otherwise it's between 20 and 99.

Select Case Val(Left(MyTens, 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

' Convert ones place digit.

Result = Result & ConvertDigit(Right(MyTens, 1))

End If

ConvertTens = Result

**End Function**

**Private Function ConvertDigit (ByVal MyDigit)**

Select Case Val(MyDigit)

Case 1: ConvertDigit = "One"

Case 2: ConvertDigit = "Two"

Case 3: ConvertDigit = "Three"

Case 4: ConvertDigit = "Four"

Case 5: ConvertDigit = "Five"

Case 6: ConvertDigit = "Six"

Case 7: ConvertDigit = "Seven"

Case 8: ConvertDigit = "Eight"

Case 9: ConvertDigit = "Nine"

Case Else: ConvertDigit = ""

End Select

**End Function**

This article shows you how to create a sample, user-defined function named ConvertCurrencyToEnglish() to convert a numeric value to an English word representation. For example, the function will return the following words for the number 1234.56:

The Function Wizard can also be used to enter a custom function in a worksheet. To use the Function Wizard, follow these steps:

1. Click the Function Wizard button, and select User Defined under Function Category.

2. Select ConvertCurrencyToEnglish, and enter your number or cell reference.

3. Click Finish

1. Insert a module sheet into a workbook. To do this in Microsoft Excel 97 or Microsoft Excel 98, point to Macro on the Tools menu, and then click Visual Basic Editor. In the Visual Basic Editor, click Module on the Insert menu. In Microsoft Excel 5.0 or 7.0, point to Macro on the Insert menu and click Module.

2. Type the following code into the module sheet.

Dim Temp

Dim Dollars, Cents

Dim DecimalPlace, Count

ReDim Place(9) As String

Place(2) = " Thousand "

Place(3) = " Million "

Place(4) = " Billion "

Place(5) = " Trillion "

' Convert MyNumber to a string, trimming extra spaces.

MyNumber = Trim(Str(MyNumber))

' Find decimal place.

DecimalPlace = InStr(MyNumber, ".")

' If we find decimal place...

If DecimalPlace > 0 Then

' Convert cents

Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)

Cents = ConvertTens(Temp)

' Strip off cents from remainder to convert.

MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

End If

Count = 1

Do While MyNumber <> ""

' Convert last 3 digits of MyNumber to English dollars.

Temp = ConvertHundreds(Right(MyNumber, 3))

If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

If Len(MyNumber) > 3 Then

' Remove last 3 converted digits from MyNumber.

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop

' Clean up dollars.

Select Case Dollars

Case ""

Dollars = "No Dollars"

Case "One"

Dollars = "One Dollar"

Case Else

Dollars = Dollars & " Dollars"

End Select

' Clean up cents.

Select Case Cents

Case ""

Cents = " And No Cents"

Case "One"

Cents = " And One Cent"

Case Else

Cents = " And " & Cents & " Cents"

End Select

ConvertCurrencyToEnglish = Dollars & Cents

Dim Result As String

' Exit if there is nothing to convert.

If Val(MyNumber) = 0 Then Exit Function

' Append leading zeros to number.

MyNumber = Right("000" & MyNumber, 3)

' Do we have a hundreds place digit to convert?

If Left(MyNumber, 1) <> "0" Then

Result = ConvertDigit(Left(MyNumber, 1)) & " Hundred "

End If

' Do we have a tens place digit to convert?

If Mid(MyNumber, 2, 1) <> "0" Then

Result = Result & ConvertTens(Mid(MyNumber, 2))

Else

' If not, then convert the ones place digit.

Result = Result & ConvertDigit(Mid(MyNumber, 3))

End If

ConvertHundreds = Trim(Result)

Dim Result As String

' Is value between 10 and 19?

If Val(Left(MyTens, 1)) = 1 Then

Select Case Val(MyTens)

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

' .. otherwise it's between 20 and 99.

Select Case Val(Left(MyTens, 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

' Convert ones place digit.

Result = Result & ConvertDigit(Right(MyTens, 1))

End If

ConvertTens = Result

Select Case Val(MyDigit)

Case 1: ConvertDigit = "One"

Case 2: ConvertDigit = "Two"

Case 3: ConvertDigit = "Three"

Case 4: ConvertDigit = "Four"

Case 5: ConvertDigit = "Five"

Case 6: ConvertDigit = "Six"

Case 7: ConvertDigit = "Seven"

Case 8: ConvertDigit = "Eight"

Case 9: ConvertDigit = "Nine"

Case Else: ConvertDigit = ""

End Select

Apr 15, 2010 | Broderbund Learn MS Windows XP and Excel...

Here is a website that should be helpful...

http://www.novaroma.org/via_romana/numbers.html

http://www.novaroma.org/via_romana/numbers.html

Mar 17, 2010 | Office Equipment & Supplies

Hello,

The syntax of the command is as follows

**:Request** Message, VarName

where Message is a character string containing the message that will be displayed as a prompt, and VarName is the name of**the string variable where the input will be stored. **

If you want to input a numerical value you must convert it from character string to a numerical value (I know, it is like splitting hair but string 123456 is not the same as number 123456)

You convert from string to numerical value with the**expr() command.**

**Exemple:**

:Request "Value of a? ", s

:expr(s) --> a

That should do it.

Hope it helps.

The syntax of the command is as follows

where Message is a character string containing the message that will be displayed as a prompt, and VarName is the name of

If you want to input a numerical value you must convert it from character string to a numerical value (I know, it is like splitting hair but string 123456 is not the same as number 123456)

You convert from string to numerical value with the

:Request "Value of a? ", s

:expr(s) --> a

That should do it.

Hope it helps.

Oct 15, 2009 | Texas Instruments TI-89 Calculator

Hello desireejane,

One method is to do the following

public static long octalToDecimal(String octal) throws NumberFormatException {

// Initialize result to 0

long res = 0;

// Do not continue on an empty string

if (octal.isEmpty()) {

throw new NumberFormatException("Empty string is not an octal number");

}

// Consider each digit in the string

for (int i = 0; i < octal.length(); i++) {

// Get the nth char from the right (first = 0)

char n = octal.charAt(octal.length() - (i+1));

int f = (int) n - 48;

// Check if it's a valid bit

if (f < 0 || f > 7) {

// And if not, die horribly

throw new NumberFormatException("Not an octal number");

} else {

// Only add the value if it's a 1

res += f*Math.round(Math.pow(2.0, (3*i)));

}

}

return res;

}

One method is to do the following

- Convert the octal, hexadecimal or binary to decimal.
- Add or Subtract the decimal normally
- Convert the result back to octal, hexadecimal or binary.

**Convert the octal to decimal:**

public static long octalToDecimal(String octal) throws NumberFormatException {

// Initialize result to 0

long res = 0;

// Do not continue on an empty string

if (octal.isEmpty()) {

throw new NumberFormatException("Empty string is not an octal number");

}

// Consider each digit in the string

for (int i = 0; i < octal.length(); i++) {

// Get the nth char from the right (first = 0)

char n = octal.charAt(octal.length() - (i+1));

int f = (int) n - 48;

// Check if it's a valid bit

if (f < 0 || f > 7) {

// And if not, die horribly

throw new NumberFormatException("Not an octal number");

} else {

// Only add the value if it's a 1

res += f*Math.round(Math.pow(2.0, (3*i)));

}

}

return res;

}

Mar 24, 2009 | Sun Java Programming Language (cdj-275)

hi prem,

i really cant answer your question but im hopeful that maybe this link will help you in your troubles.

thanks for using fixya

i really cant answer your question but im hopeful that maybe this link will help you in your troubles.

thanks for using fixya

Mar 30, 2008 | Computers & Internet

Well, one solution is to fetch the whole data, including the non-numeric part, and then convert that into a number. Most programming languages strips off the non-numeric part of a string when converting into a number. For example, converting '24Michell' to a number will result into '24'. Consult your programming manual on how to convert a string into a number.

Oct 01, 2007 | Microsoft SQL Server Standard Edition for...

Aug 20, 2013 | Microsoft Office Standard for PC

42 people viewed this question

Usually answered in minutes!

Its not Working

×