Can i generate a UUID/GUID in numbers

There is a wikipedia article:

http://en.wikipedia.org/wiki/Universally_unique_identifier#Version_4_.28random.2 9

Assuming you want to make "Version 4" UUID:

You can make a table with columns for:

- Version which is always "4"

- Y which may be the digit 8, 9, A, or B

- 30 columns which contain a random value from the set 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F (hexidecimal digits)

the formula for C2=NUMTOBASE(RANDBETWEEN(8, 11), 16)

Fill this straight down

D2 =NUMTOBASE(RANDBETWEEN(0,15), 16)

fill to the right, then fill cell D2 - AG1 down

B2 should be 4

fill down (copy , then select range B3 to the end, then paste)

B2=D2&E2&F2&G2&H2&I2&J2&K2&"-"&L2&M2&N2&O2&"-"&B2&P2&Q2&R2&"-"&C2&S2&T2&U2&"-"&V 2&W2&X2&Y2&Z2&AA2&AB2&AC2&AD2&AE2&AF2&AG2

fill down

To get the results out you can select the UUID column, copy, then use the menu item "Edit > Paste Values"