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.


--
Exceler
------------------------------------------------------------------------
Exceler's Profile: http://www.excelforum.com/member.php...o&userid=36221
View this thread: http://www.excelforum.com/showthread...hreadid=560141

Show decimal point only if not a whole number
 

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=560141

Show decimal point only if not a whole number
 

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