Converting String numbers into real numbers

  • Thread starter Thread starter Werner
  • Start date Start date
W

Werner

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting String numbers into real numbers 2
Excel Convert word into numbers and back 4
Concatenate VBA results and an * in a cell 4
Cells formatting done without me allowing it in VBA 2
Convert a range of numbers to strings 2
Conversion from Number to Word!! Aki 1
Fourier, numbers-as-text, and macros. 9
Convert date to serial number 12

Back
Top