Number Formatting

I'm trying to make a custom number format that displays both decimals only when needed but also uses the thousands separator comma. For example...

1,000
1,000.14
45.22
35
35,000
35,000.56

Is this possible?

Thanks!

Try a format of

#,##0

Then a conditional format rule of (A1 in the formula should refer to the cell that you're trying to format, or the active cell if applied to a range).

=MOD(A1,1)

With a format of

#,##0.0#

@jason.b75 small oversight..
I think that CF condition does not result in True or False so change it to

Formula:

Please Login or Register  to view this content.

to work as CF condition

@Roel, CF doesn't need true or false to function.

Any non zero numeric value will be evaluated as true (positive or negative).

Everything else, zero values, text, untrapped errors and anything I may have forgotten all evaluate as false.

ah, cool, you are right... did not know that..
always something new to learn.. was pretty sure about this one

Thanks! Very much appreciated, this forum is wonderful