Philippe L. Balmanno wrote...
...
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?
You'd need to use VBA. If by 're-enter' you mean open the file in a
subsequent Excel session, then I believe you'd be better off using a
macro to fill the cells containing this formula with random integers
between 1 and 7.
---------
www.coffeecozy.com
Use your Bodum and give up cold coffee for good!