I need to import decimal numbers from text files into Excel without losing
format (e.g. trailing zerors are preserved "2.00").

I know that you can import the decimal numbers into Excel as text then the
trailing zeros will be preserved. However, I want Excel to treat the values
as numbers, preserving the decimals and trailing zeros.

Is this possible?

Thanks,
Jack