I am working on a data import for work that contains rows with varying numbers of digits in each row. However, I need each to be comma separated (every 2) to work in the import.
A few things:

- The numbers vary in every row. It could be XXX or XXXXXXXXXXXXXXXXX
- The commas need to be coming from the right so X,XX or X, XX, XX, XX, XX, XX, XX, XX, XX

If the number of digits was the same in every row this wouldn't be an issue, but because they vary, I cannot find a solution to this.

I should add I tried formatting the number as XX, XX, XX, XX in the number format screen but it does not hold. I also tried ##","##","##","##","## but that leaves extra commas if there are not enough numbers in the cell, which will not work in my import.

Any ideas?!

Thanks in advance!