Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting String numbers into real numbers
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 -- Werner ------------------------------------------------------------------------ Werner's Profile: http://www.excelforum.com/member.php...o&userid=24304 View this thread: http://www.excelforum.com/showthread...hreadid=382503 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting String numbers into real numbers
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 -- theDude ------------------------------------------------------------------------ theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550 View this thread: http://www.excelforum.com/showthread...hreadid=382503 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting list of numbers in Excel to a string of text in Word | Excel Discussion (Misc queries) | |||
converting positive numbers to negative numbers | Excel Discussion (Misc queries) | |||
Converting positive numbers to negative numbers | Excel Worksheet Functions | |||
Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
Converting String numbers into real numbers | Excel Programming |