PDA

View Full Version : random



oleg_v
08-03-2010, 01:49 AM
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

Simon Lloyd
08-03-2010, 02:08 AM
format your cell as number to 4 decimal places!

oleg_v
08-03-2010, 02:20 AM
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.

GTO
08-03-2010, 02:41 AM
Have you tried INT() or TRUNC() or ROUND() ?

Simon Lloyd
08-03-2010, 03:38 AM
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.The "fx" is the formula bar and you will see the full number there, it's the cell you are truncating!

How about a workbook?