Search results

Additionally, you may want to check if result of format function is numeric, if you are converting user-entered value for example, Format("23%", "General Number") = 0,23, which is a number but Format("%", "General Number") = "%" and Format("", "General Number") = "" which are not numeric if...

There is one VERY elegant solution: use FORMAT function e.g. Valuenum3 = Format(Value) or Valuenum3 = Format(Value,"General Number")