Hey Guys and Gals,

I'm importing lots of data from lab results on to spreadsheets. I want to standardize data that's been imported by different people over many years. I would like only one zero to be displayed if there are no other numbers in the tenth's/hundredth's place. The issue is, I believe, that most of the data has a < (less than) sign in front of the number, signifying that it was below the detection threshold. This "<" doesn't allow me to simply use the "move decimal point" button.

Could anyone help me with writing a custom number format code that would display only one zero to the right of the decimal point in the tenth's place but only if there are no other numbers present.

TLDR: I have many <1.00, <3.00, and <5.00s. Want to make them <1.0, <3.0, <5.0 while preserving data such as 1.98, 0.56, etc...

Thanks!