Random number generator
Used to determin random scheduling in a week.
I have two columns, the first column contains =INT(RANDBETWEEN(1,7))
and the second converts the out put of the first into a day of the
week.
When I save the sheet and then re enter it, the days are recalculated
and I don't want it to do this until I ask it to.
Is there a way to just copy the value output of the weekday formula
without copying that formula so that I can save this run?
Thanks in Advance,
Phil
|