anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
I have numbers in column A that look like this
<tbody>
</tbody>
But when I click in the formula bar they are really this (real numbers)
<tbody>
</tbody>
What I need to do is to is put the numbers into sets of 3 from right to left
<tbody>
</tbody>
13,065,102 |
13,165 |
4,051,065 |
600 |
18,013,092 |
<tbody>
</tbody>
But when I click in the formula bar they are really this (real numbers)
13065102 |
13165 |
4051065 |
600 |
18013092 |
<tbody>
</tbody>
What I need to do is to is put the numbers into sets of 3 from right to left
13065102 | 013 | 065 | 102 |
13165 | 013 | 165 | |
4051065 | 004 | 051 | 065 |
600 | 600 | ||
18013092 | 018 | 013 | 092 |
<tbody>
</tbody>