custom formating numbers

[JK]

I have a column of numbers, I want to format the numbers in a different
column using two different custom formats. Do i need an IF formula that will
Identify which number chooses which format if so what would it be .

i.e
6,500,000 = 6500
839,153 = 839153.

Thanks in advance

 

[Fred Smith]

As long as the break point is consistent (ie, 1,000,000), you can do it with
a custom format, as in:

[<1000000]0;[>=1000000]0,

Regards,
Fred.