View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LaBonita LaBonita is offline
external usenet poster
 
Posts: 1
Default 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