Hello,

Is it possible to split contents of a cell based on if the cell value is
greater than 10000000, if true the result would be 1,000,0000, if not copy
the cell value.

All the numbers are either heigher or lower than 10000000.

Thanks

Dejan