View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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