G Guest Oct 25, 2004 #1 I can't get the answer on Help. I don't want the decimal places rounded off. I need to show the two numbers as in 2 decimal places.
I can't get the answer on Help. I don't want the decimal places rounded off. I need to show the two numbers as in 2 decimal places.
G Gord Dibben Oct 25, 2004 #2 Format>Cells>Number>Number. Set to two decimal places. Also check Format>Style>Normal. You can modify the default Number here to make sure every number shows two decimals. Gord Dibben Excel MVP
Format>Cells>Number>Number. Set to two decimal places. Also check Format>Style>Normal. You can modify the default Number here to make sure every number shows two decimals. Gord Dibben Excel MVP
