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