If that's the only change, you could select the range to fix:

Edit|replace
what: <
with: <0.00
replace all

or
what: <1
with: <0.001
replace all

Or a bunch of combinations like this.

justinbeau wrote:

Need to due a number of conversions from ug -- mg in a column. Many of the
numbers that I need to convert have a "less than" sign... ie <1 should
convert to <0.001

--

Dave Peterson