I am creating a spreadsheet of laboratory results and many of the values are
less that detection limits, while other values require decimals. Cells in a
column may be as follows:
< 10.00
5.62

I type in all these values, then format cells to "number" and "2 decimals".
The result is;
< 10
5.62

For consistency, I want to retain the decimals. How do I do that formating?
Thanks.