0333 ! = 333 but it is. Another way around it?

Sep 1, 2009 at 10:56 PM

I am running into a problem.  I have the following formula, well I simplified this one.

0333 = 333

This always evals to true since 0333 is technically a number.  We now I am told that this should not return true since the codes 0333 and 333 would have different meanings.  Is there any way to handle this without turning into a string and comparing strings.

I could have an expression that looked like

(0419.45 = 419.45) OR (0419.46 = 419.45) OR (0419.47 = 419.45) OR (0419.48 = 419.45) OR (0419.49 = 419.45)  .....etc

I would like to do something like:

(419.45 >= 0419.10) AND (419.45 <= 0419.99)  and it still return false.  I don't want to have to write out an expression string for each number incrementing my .1 since I could be talking about a range from .1 to 999.

I hope this makes sense. 

Thanks for your help,

Jason