Hi
how can i control the precision of random function.
i need instead of 2.36666664584 to be only 4 numbers after the point 2.3666
thanks
Hi
how can i control the precision of random function.
i need instead of 2.36666664584 to be only 4 numbers after the point 2.3666
thanks
format your cell as number to 4 decimal places!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Hi
It does not working after i do the format your cell as number to 4 decimal places i select the cell and i can see on (fx) row above that it does not change.
Have you tried INT() or TRUNC() or ROUND() ?
The "fx" is the formula bar and you will see the full number there, it's the cell you are truncating!Originally Posted by oleg_v
How about a workbook?
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)