03-17-2010 12:49 PM
ACT 2010 SP1
I have created a text field that contains mostly numbers, but I wanted a text field because it might show the number of employees as "1,000 => 850" meaning that they would be downsizing. Another would be "1,000=650 @ HQ and 350 @ Branches"
Is there a way to logically do a lookup that would treat this field as a number lookup?