LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Les Coover
 
Posts: n/a
Default Random Numbers Change?

MS Excel 2000

Used the function

=INT(RANDBETWEEN(1,5)

to generate a list of random numbers.
Protected the sheet and left the
the range the function is in
locked.

Other parts of the sheet
unlocked.

Why is it that when I enter data
in unlocked cells that the list
of random numbers changes.

I needed to protect my random
generated data from changes
so I copied it as values to
another range and locked that
range so no changes can be
entered.

But I was wondering why the
cells with

=INT(RANDBETWEEN(1,5)

in them change when I am entering
data in other areas of the sheet.

Thanks,

Les


 
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
Generate random numbers 1-100 without any repeats? ExcelFan Excel Worksheet Functions 4 May 5th 23 07:46 PM
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Is there an automatic way to change numbers such as 12312001 t curtev Excel Discussion (Misc queries) 1 December 29th 04 10:32 PM
how do you change invoice numbers automaticly wendy New Users to Excel 1 December 11th 04 12:42 AM
generate random numbers Jules Excel Worksheet Functions 6 November 2nd 04 05:57 PM


All times are GMT +1. The time now is 06:33 PM.

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"