Article ID: 145695 - Last Review: May 7, 2003 - Revision: 2.0

PRB: Error Converting String to Numeric Value When Using "%"

View products that this article applies to.
This article was previously published under Q145695

On This Page

Expand all | Collapse all

SYMPTOMS

When converting a string that represents a percentage with the percent (%) character, you receive the following error:
Run-time error '13':
Type Mismatch
You may receive this error using the CDbl, CSng, CCur, or CDec conversion functions.
Back to the top

MORE INFORMATION

Steps to Reproduce the Problem

  1. Start a new project in Visual Basic.
  2. In the Debug Window (or Immediate Window), type the following and press the ENTER key:
    ?CDbl("12.00%")
  3. You receive the run-time error "Type Mismatch".
  4. To correctly convert "12.00%" to a numeric representation, type the following in the Debug Window and press the ENTER key:
    ?CDbl(Format("12.00%", "0.00"))
  5. You should receive the results 0.12 as expected.
Back to the top
APPLIES TO
  • Microsoft Visual Basic 5.0 Learning Edition
  • Microsoft Visual Basic 6.0 Learning Edition
  • Microsoft Visual Basic 5.0 Professional Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic 6.0 Enterprise Edition
  • Microsoft Visual Basic 4.0 Standard Edition
  • Microsoft Visual Basic 4.0 Professional Edition
  • Microsoft Visual Basic 4.0 Enterprise Edition
  • Microsoft Visual Basic for Applications 5.0
Back to the top
Keywords: 
kbprb KB145695
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations