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