Number Break Down

[Jerry HKA]

Hi everyone,

Could anyone make a VBA function to break down a 4 digit number into multiple selection of three number. I have an example attached to this thread, please refer to it, the numbers highlighted in red are the original numbers, and the ones that are not, are the desired results. If not understood, please PM me for more information about the function. Or you may just post it on the thread.

[jindon]

See if this works.

[Jerry HKA]

Hi Jindon,

Thank you for the code, it is working marvelously perfect. But could you please show me the VBA code. I really need to know. And by the way, the attached is only one part of the file, what should I do if I have to use the VBA code for many of that is what in the attached? Please answer, and post the VBA code. Thank you once again.

[jindon]

Here

Please Login or Register  to view this content.

[Jerry HKA]

Thank you very much for your help, I hope you can help me again the next time.

[Jerry HKA]

Hi Jindon, what about if I want to use the code on many of that is was in the workbook, what should I do? And there is still one more problem, the computer won't recognize a number that starts with 0. Whenever I write a number that starts with 0, ex. 0976, 0964 and so on, the result would be, 679 and 469 respectively. The result should be. 067,069,079 and 046,049,069 respectively. Please help to approach the code. Thank you.

[jindon]

Hi Jindon, what about if I want to use the code on many of that is was in the workbook, what should I do? And there is still one more problem, the computer won't recognize a number that starts with 0. Whenever I write a number that starts with 0, ex. 0976, 0964 and so on, the result would be, 679 and 469 respectively. The result should be. 067,069,079 and 046,049,069 respectively. Please help to approach the code. Thank you.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Jerry HKA]

What should I do if I want to apply it in many places as like in the attached? That in the attached is just a part of the worksheet, could you tell me how to apply it to many places, because it seems to only work at that one certain place. Please try to help.

[Jerry HKA]

Please help, jindon.

[jindon]

Please Login or Register  to view this content.

[Jerry HKA]

Thank you, Jindon. I very much thank you as much as a thousands of milions of times. This helped me billions. Thank you so much.