I want to be able to type 1 and display .01, then type 1. and get 1.00 How do I accomplish this?
D Diana Nov 30, 2005 #1 I want to be able to type 1 and display .01, then type 1. and get 1.00 How do I accomplish this?
N Niek Otten Nov 30, 2005 #2 Tools>Options>Edit, check Fixed decimal and make the number of decimals 2. Format your cells accordingly.
Tools>Options>Edit, check Fixed decimal and make the number of decimals 2. Format your cells accordingly.
