custom formating numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JK - 24 May 2008 04:21 GMT

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

Reply to this Message

Fred Smith - 24 May 2008 04:37 GMT

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.

>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
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message