Show decimal point only if not a whole number

I'd like to clean up the appearance of a spreadsheet by showing a decimal point only if the value is not a whole number, as well as limit the number of decimal places.

Conditional formatting allows formulas to specify a condition, such as =A1=Int(A1), but I can't figure out how to specify a number format (instead of a color) as a result.

Use the command Format\Cells\Number. To do what you want, you should either select General format 0 which will give you exactly what is typed, or alternatively 0.### with one hash for each decimal place you want to display

Matt

Right-click > FormatCells > NumberTab > Custom > 0.## in the Type: window >
Ok.........this will format to give a decimal point and no digits after for
whole numbers and one to two decimal places max for those numbers with
decimals.

hth
Vaya con Dios,
Chuck, CABGx3

"Exceler" wrote:

>
> I'd like to clean up the appearance of a spreadsheet by showing a
> decimal point only if the value is not a whole number, as well as limit
> the number of decimal places.
>
> Conditional formatting allows formulas to specify a condition, such as
> =A1=Int(A1), but I can't figure out how to specify a number format
> (instead of a color) as a result.
>
>
> --
> Exceler
> ------------------------------------------------------------------------
> Exceler's Profile: http://www.excelforum.com/member.php...o&userid=36221
> View this thread: http://www.excelforum.com/showthread...hreadid=560141
>
>

Is their a format for showing only a decimal point when the number is not whole and also hide zeros?

I use Office 2003.

If I use the code suggested below [FormatCells > NumberTab > Custom > 0.##]... a number such as "88.25" displays correctly -
BUT if the number becomes "88" (as a result of a formula calculation) then the display becomes "88." (The decimal point SHOWS, even though the trailing zeros don't)

So, the suggested solution does not really work.

I COULD keep the 'Number Format' as 'General' - that way a number WITHOUT decimal figures would show as "88" - and when it acquires a decimal value, it would show as "88.25"...

But actually, I want to set up a CUSTOM FORMAT... where:-
"88" would show as "88 Man-Days" (#0" Man-Days")
"88.25" would show as "88.25 Man-Days" (#0.##" Man-Days")

Is there any way of doing that?

Originally Posted by CLR

Right-click > FormatCells > NumberTab > Custom > 0.## in the Type: window >
Ok.........this will format to give a decimal point and no digits after for
whole numbers and one to two decimal places max for those numbers with
decimals.

hth
Vaya con Dios,
Chuck, CABGx3

"Exceler" wrote:

>
> I'd like to clean up the appearance of a spreadsheet by showing a
> decimal point only if the value is not a whole number, as well as limit
> the number of decimal places.
>
> Conditional formatting allows formulas to specify a condition, such as
> =A1=Int(A1), but I can't figure out how to specify a number format
> (instead of a color) as a result.
>
>
> --
> Exceler
> ------------------------------------------------------------------------
> Exceler's Profile: http://www.excelforum.com/member.php...o&userid=36221
> View this thread: http://www.excelforum.com/showthread...hreadid=560141
>
>

Select CUSTOM FORMAT still needs to be general not number i.e. [General "Man-Days"]