Setting length of data in Excel

[LaBonita]

Is there a way to format imported data to always have 5 digits or
characters... no matter where the decimal point appears.
Example:
12.345
1.2345
123.45
1234.5

Thanks

 

[Ron Rosenfeld]

Is there a way to format imported data to always have 5 digits or
characters... no matter where the decimal point appears.
Example:
12.345
1.2345
123.45
1234.5

Thanks

What do you want to do about trailing zero's?

In other words, what if the imported number is 12?

Is 12 sufficient for display, or do you need 12.000?

--ron