Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've created a spredsheet using the Rand function but everytime I do
something the numbers change. How do i freeze the numbers generated or remove the function but leave the number generated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Select the range (column/row) containing the random numbers -- Right-click "Copy" -- Right-click "Paste Special" -- "Values" -- "OK". Regards, B. R. Ramachandran "Steven" wrote: I've created a spredsheet using the Rand function but everytime I do something the numbers change. How do i freeze the numbers generated or remove the function but leave the number generated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Number generator | Excel Worksheet Functions | |||
Random letter and number generator | Excel Worksheet Functions | |||
random number generation | Excel Worksheet Functions | |||
random number without repeating? | Excel Worksheet Functions | |||
Random Number Questions | Excel Worksheet Functions |