convert "less than" value from ppb to ppm

[rlihle1]

Need a formula to change values from parts per billion to parts per million,
but need to have formula to check for "less than" and complete conversion.

51 would be 0.051
<5 would be <0.005
THANKS

 

[Fred Smith]

=if(left(a1,1)="<","<"&right(a1,len(a1)-1)/1000,a1/1000)

Regards,
Fred

 

[Jacob Skaria]

Try
=IF(N(A1),"",LEFT(A1,1))&IF(N(A1),A1/1000,MID(A1,2,99)/1000)