Special Text Formatting

I'm trying to input a product version number into excel in the form of X.X.X

Based on these versions, I have a conditional formatting rule set up when the next iteration is met. The problem I run into is when I have a version, for example 4.6.9 get updated to 4.6.10

Because excel reads the number after the second decimal as the most significant, or because 9>1, my conditional formatting is thrown off. Does anyone know a workaround for this, or some special text rule I could use to have excel evaluate this properly?

Thanks!

oeldere,

I forgot to specify that this data is imported from another data source, so manually going through and inserting the zero isn't exactly what I was hoping for. I was thinking of inserting a separate column to create a formula that would make the default text formatted as X.X.XX as you said, I just don't know what that formula would look like.

I'm not sure if my last response was posted, but I went with Romp's solution. AlKey, Romp was correct, when using your formula, it still treats a version number such as 3.5.10 as 03.05.010

Thank you everyone for helping out so quickly!