Regular Expression Pattern May Include Decimal

Hi all,

Using Excel 2010 with reference to Microsoft VBScript Regular Expressions 5.5
Sometime my string may include a decimal, sometimes not: 99.5, 99, 100, 98.7, etc

How can I modify my pattern to include the decimal and any number trailing (.x or .xx)

The code below is returning 99.00, should be 99.50

thx
w

Please Login or Register  to view this content.