Just to add some info -

You don't need the INT() function. It's doing nothing.
Well, nothing useful. RANDBETWEEN will only return
integers.(unless this has been changed in XL 2003 and up ?)

You can enter decimal values as arguments but the decimal
is ignored.

Biff

-----Original Message-----
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
.