Sam,

Do you want the prime factors?

12 = 2,2,3

or all possible factors?

12= 1,2,3,4,6,12

HTH,
Bernie
MS Excel MVP


"Sam" wrote in message
...
how can i factorise numbers on excel e.g. get all the factors of the
number i
input?