Setting length of data in Excel

L

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
 
R

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
Click to expand...

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
 
Top