prime number

hi


in excell 2010


I want column A decomposition into prime number and then write result in column B


for example

A........................... B



12..........................2^2×3

13 .........................13

10..........................2×5

8...........................2^3

23 .........................23

30.........................2×3×5

............................. ......



please give me a vba code

See this thread
[SOLVED] how do I find prime factors of a number
And this link
Chip Pearson - Testing Prime Numbers In Excel

Also,

It has come to our attention you have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

All questions and answers will benefit other posters like yourself. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harrasment by most of our contributors and will not be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.

Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.