Digits after decimal

[Guest]

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

 

[NickHK]

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

 

[Guest]

Thanks Nickhk

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