VAL to convert thousands...

Hello,

I'm using VAL to convert some strings into numbers, and it would appear that MS has once again implemented stupidity at the lowest level.

VAL is converting "3,000.00" to 3.0, or "6,150.00" to 6.0. In other words, since comma is not a valid number it's stopping right there. Completely ignoring the fact that a comma is a valid part of a number string in those crazy little countries like America.

Any ideas? I do NOT want to go through and put a freaking Replace() funciton everywhere in my code I use VAL.

Thanks,

Ben

Use CDbl, CInt, CDec, etc.

Or, the .NET way:

int32.Parse, and also System.Convert