#### dramnath1981

##### Member

Please help me in converting a number in to the following format.

Eg: 368002

Solution expected

300000

60000

8000

2

Eg: 300002

Solution expected

300000

2

Assumptions:

- The sum of the broken down numbers should be equal to the original value

- There won't be any decimals

- Results can be displayed in different cells (say 30000 in B1, 6000 in B2, 8000 in B3)

Any solution, either through Excel / VBA would be of great help. Its a kind of urgent.

Thanks guys for all your help.

Regards,

Ramnath