Generate a serial number?
Can I set up a sheet so that there is a column that automtically generates a serial number?
MacBook Pro, 17", Mac OS X (10.4.7)
Can you tell us more? Is there any special format to the serial numbers you want? Are they digits or a letters or a combination of both?
The random number generator (the RAND() or RANDBETWEEN() function) will generate a random number but the number will change every time you make a change to a cell or open your file.
You can have a cell that generates a random number using the RAND() function as part of the formula. You can copy and "paste values" that random number to another cell to "lock in" that number.
You can create a column of cells that generate random numbers. You can copy one of them and "paste values" back into the cell to lock that particular one in.
You can format these cells so all digits (including any leading zeros) are displayed and so that there are dashes or other punctuation between every so many digits, etc.
The random number generator (the RAND() or RANDBETWEEN() function) will generate a random number but the number will change every time you make a change to a cell or open your file.
You can have a cell that generates a random number using the RAND() function as part of the formula. You can copy and "paste values" that random number to another cell to "lock in" that number.
You can create a column of cells that generate random numbers. You can copy one of them and "paste values" back into the cell to lock that particular one in.
You can format these cells so all digits (including any leading zeros) are displayed and so that there are dashes or other punctuation between every so many digits, etc.
