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
>
>
Bookmarks