Setting length of data in Excel
 

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

Setting length of data in Excel
 

On Tue, 4 May 2010 16:31:01 -0700, LaBonita
wrote:

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