Prev: How can I detail Pivot Table data without creating a table (Excel 2007)
Next: VBA Copy values only onto new workbook
From: LaBonita on 4 May 2010 19:31
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
From: Ron Rosenfeld on 4 May 2010 21:12
On Tue, 4 May 2010 16:31:01 -0700, LaBonita
<LaBonita(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: How can I detail Pivot Table data without creating a table (Excel 2007)
Next: VBA Copy values only onto new workbook