Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1
lace><st1:stockticker>RAND</st1:stockticker></st1
lace>()*(99999999-11111111)+11111111,8)” to generate a random 8-digit number.
<o
></o
>
1) The formula works – Yay for me!!!
2) I have turned off the sheet’s auto-calc function and must press “F9” for a calculation – that’s fine
<o
></o
>
Now what I need:
a) To PERMANENTLY capture the number generated in “A1” somewhere. The captured number CAN NOT change every time I press F9 in the <st1
lace><st1:stockticker>RAND</st1:stockticker></st1
lace> sheet. I’d prefer it to be captured somewhere on the same sheet (i.e “D1”, etc.). Alternately, it could be captured in a new tab/sheet in the same workbook, or lastly in a new workbook.
b) To place a minus (“-“) sign between digits #4 &5 (e.g. xxxx-xxxx)
c) That once a number is used, it is disallowed from future possibilities
<o
></o
>
I tried using <st1
lace>two <st1:stockticker>RAND</st1:stockticker></st1
lace>’s with 4-digits each, but could not put them together in a single cell with the minus sign and still had the problem of the number changing.
<o
></o
>
The reason I need to permanently capture the number is that it will be assigned to an employee as their ID number.
Finally, I know what the words VBA stand for, but have never used it and was hoping to be able to accomplish my task with formula and function within excel.
<o
></o
>
TIA,
<o
></o
>
gsacorp
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com



<o


1) The formula works – Yay for me!!!
2) I have turned off the sheet’s auto-calc function and must press “F9” for a calculation – that’s fine
<o


Now what I need:
a) To PERMANENTLY capture the number generated in “A1” somewhere. The captured number CAN NOT change every time I press F9 in the <st1


b) To place a minus (“-“) sign between digits #4 &5 (e.g. xxxx-xxxx)
c) That once a number is used, it is disallowed from future possibilities
<o


I tried using <st1


<o


The reason I need to permanently capture the number is that it will be assigned to an employee as their ID number.
Finally, I know what the words VBA stand for, but have never used it and was hoping to be able to accomplish my task with formula and function within excel.
<o


TIA,
<o


gsacorp