Splitting Cell Contents with a comma
 

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

It's not clear whether you mean one million or ten million. For one million
use the formula:

=MIN(cell with value,1000000)

If it's ten million, add a zero

"Dejan" wrote:

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