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"]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.