Dear Forum,

Can any body know the formula or syntax

I want to fix number of digits after the decimal in a frist position of the
array. from the same array the subsequent cells should be fixed based on the
first cell of the array .

For example 0.254 if i put in first cell the subequent cell of the array
should also have 3 digit after decimal.

Thanks in advance

Sthappali

Do you mean you want the .Value to have the same of decimal places or that
the .Text should be formatted to appear that way ?
Check out the difference between a cell's .Value and .Text. Also
..NumberFormat.

Also, by "array" do you mean a range of cells or a VBA array of singles ?
e.g. Dim DecimalArray(1 to 1000 as single

NickHK

"Sthappali" <(E-Mail Removed)> wrote in message
news:E1CE3CAE-6DFF-469C-84FB-(E-Mail Removed)...
> Dear Forum,
>
> Can any body know the formula or syntax
>
> I want to fix number of digits after the decimal in a frist position of
the
> array. from the same array the subsequent cells should be fixed based on
the
> first cell of the array .
>
> For example 0.254 if i put in first cell the subequent cell of the array
> should also have 3 digit after decimal.
>
> Thanks in advance
>
> Sthappali
>

Thanks Nickhk

"NickHK" wrote:

> Do you mean you want the .Value to have the same of decimal places or that
> the .Text should be formatted to appear that way ?
> Check out the difference between a cell's .Value and .Text. Also
> ..NumberFormat.
>
> Also, by "array" do you mean a range of cells or a VBA array of singles ?
> e.g. Dim DecimalArray(1 to 1000 as single
>
> NickHK
>
> "Sthappali" <(E-Mail Removed)> wrote in message
> news:E1CE3CAE-6DFF-469C-84FB-(E-Mail Removed)...
> > Dear Forum,
> >
> > Can any body know the formula or syntax
> >
> > I want to fix number of digits after the decimal in a frist position of
> the
> > array. from the same array the subsequent cells should be fixed based on
> the
> > first cell of the array .
> >
> > For example 0.254 if i put in first cell the subequent cell of the array
> > should also have 3 digit after decimal.
> >
> > Thanks in advance
> >
> > Sthappali
> >
>
>
>