hi guys - especially Zathras
(look at thread56-1281655 - 22 Sep 06)
I need to fill a column with random the numbers 0-31.
maestro Zathras wrote nice and short:
i tried to modify this solution (W1) for numbers 01 02 03 04 ..... 29 30 31 (days of month) - unsuccessfully
would you be or anybody so kind and help me ?
thanking you in advance
(look at thread56-1281655 - 22 Sep 06)
I need to fill a column with random the numbers 0-31.
maestro Zathras wrote nice and short:
A1: =MID(W1,INT(RAND()*(11-ROW(W1)))+1,1)+0
W1: '0123456789
W2: =LEFT(W1,FIND(A1,W1)-1)&MID(W1,FIND(A1,W1)+1,99)
i tried to modify this solution (W1) for numbers 01 02 03 04 ..... 29 30 31 (days of month) - unsuccessfully
would you be or anybody so kind and help me ?
thanking you in advance