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

ID: Q145695

The information in this article applies to:
  • Microsoft Visual Basic Learning, Professional, and Enterprise Editions for Windows, versions 5.0, 6.0
  • Microsoft Visual Basic Standard, Professional, and Enterprise Editions for Windows, version 4.0
  • 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.


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.


Additional query words: kbVBp400 kbVBp500 kbVBp600 kbVBp kbdsd kbDSupport kbVBA

Keywords : kbGrpVB
Version :
Platform : NT WINDOWS
Issue type : kbprb


Last Reviewed: January 5, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.