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.

"JK" wrote in message
...
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