Conditional Number Format for varying decimal places

Hi,

I have decimal numbers as text entering my spreadsheet and I need them to be converted to a number with their formats preserved. I need the trailing zeros preserved.

Here's an example column:
"213.10"
"11.2000"
"5.450"

I need each these conveted to numbers in the format of how they look:
213.10
11.2000
5.450

I tried conditional formatting that counted the number of decial places after the decimal,
and set the format accordingly, but I couldn't get it to convert it from text to number.

I must stay away from using Macros.

Thanks for any input!
-justme23

I know that I will need number format "0.00", "0.000" or "0.0000" depending on how any decimal places the number has when formatted as text. There's no way to set the appropriate number format based on a conditional format on the column?

Thanks again