Using variable to autofilter a list - trouble with trailing zeroes

[infidelatwork]

Hello

I've set up a workbook that populates with the list of "runs" that a department has open. Each run has 10's of sequences, so the total number of rows in the list can easily approach 1000. The user enters the specific run they need to update status on into a textbox, and my vba code filters the list accordingly. Unfortunately, there are some runs that don't filter properly, and I think it is related to the trailing zero. So run numbers are in the format:

...
723140127.009
723140127.010
723140127.011
...

and displayed as numbers on the sheet. However, when I convert the text entry into a number value to use as the filter criteria, it always drops that trailing zero for .010 and so the variable contains 723140127.01, and then the filter hides everything. .009 and .011 function correctly.

What I would like to know is if there is a way for me to force the variable to keep track of that 3rd decimal place, even if it's a zero, or if I will need to backtrack and make some structural changes to the sheet so I can autofilter the suffix seperately.

Thanks