LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Philippe L. Balmanno
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How to keep random number from changing using RANDBETWEEN? TXlimogirl Excel Worksheet Functions 6 April 3rd 23 04:41 PM
How can I get Positive values only from the random number generat. Markw3700 Excel Discussion (Misc queries) 1 January 21st 05 12:37 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Random # Generator vamosj Excel Worksheet Functions 0 November 8th 04 07:14 PM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"