Conditional Formatting -- Ignore "less than" (<) sign

[Tryintouseexcel]

I am trying to set up conditional formatting to flag all cells below 0.5. I am finding that cells with a less than (<) sign get flagged even if they are less than 0.5. For example when I set up conditional formatting to flag everything below 0.5 a cell with the value <0.0030 will be flagged.

How do I make excel ignore the less than sign when doing conditional formatting.

Thanks

 

[Fluff]

You're welcome & thanks for the feedback.