+ Reply to Thread
Results 1 to 2 of 2

Converting String numbers into real numbers:formula in VBA

  1. #1
    Registered User
    Join Date
    06-14-2005
    Posts
    41

    Question Converting String numbers into real numbers:formula in VBA

    Hi,

    I have a formula in VBA that searches through a table for corresponding results to the conditions I specified and sort the results into another table. My problem is that the data I use, which includes monetary values, seems to have converted them into string numbers (which include de $ sign as part of the characters and not only into a simple visual effect). It's a problem when I want to do mathematic operations with those monetary values. Is there a way to convert them into real numbers in my VBA code just before doing my maths with them? I tried to pre-format the cells before their extraction but it seems it isnt enough to really convert them.

    Thx!

    Werner

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    Hi Werner,

    This post may help:

    http://www.excelforum.com/showthread.php?t=380591

    Also, refer to your VBA help topic "Type Conversion Functions"

    theDude

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1