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
|