Digits after decimal
 

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

Digits after decimal
 

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" wrote in message
...
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

Digits after decimal
 

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" wrote in message
...
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