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

ID: Q145695

The information in this article applies to:

Microsoft Visual Basic for Windows Learning, Professional and Enterprise Editions, versions 5.0, 6.0
Standard, Professional, and Enterprise Editions of Microsoft Visual Basic, version 4.0, for Windows
Microsoft Visual Basic for Applications, version 5.0 -------------------------------------------------------------------------

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.

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.

Additional query words: kbVBp400 kbVBp500 kbVBp600 kbVBp kbdsd kbDSupport kbVBA

Platform          : NT WINDOWS
Issue type        : kbprb

Last Reviewed: August 7, 1998