val [VBA]

option explicit

public sub val_() 

  dim str as string
  str = "42.59"

  msgBox("val(" & str & "): " & val(str))

  str = "420.4 abc"
  msgBox("val(" & str & "): " & val(str))

  str = "&H2A"
  msgBox("val(" & str & "): " & val(str))

end sub


	René Nyffenegger's collection of things on the web
	René Nyffenegger on Oracle - Most wanted - Feedback - Follow @renenyffenegger