Setting length of data in Excel

  • Thread starter Thread starter LaBonita
  • Start date Start date
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
 
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
 
Back
Top