| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
| How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
| Converting a number to 2 decimal places | Excel Discussion (Misc queries) | |||
Linear Mode
