Assuming you don't want to generate a different number every time (which it seems like you don't) once you've generated them, copy them, and then paste values. See: http://office.microsoft.com/en-gb/excel-help/copy-cell-values-not-formulas-HA010244903.aspx