Number Question(Resolve Thanks[ Illspirit ] )

[Dbee]

If I have a number say 12,345.67 and I do a check of this number I get 12

So My question is the a way to take out the comma easy other than creating a routine that does an instr to find the location of the comma and then do a left and right string in order to come up with the sum 12345.67.

[Illspirit]

Dim sIn As String, fOut As Double
sIn = "123,456.789"
 
fOut = CDbl(Replace(sIn, ",", vbNullString, , , vbTextCompare))
 
MsgBox fOut

[wildbeliefs]

I'm not that experienced with VB, so I can't give you the exact code, but I'm pretty sure that the "format" function could format your number and take out the comma.