Digits after decimal

S

Sthappali

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
 
N

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
 
S

Sthappali

Thanks Nickhk

NickHK said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top