Page 1 of 1
[Solved] Setting a column @ 2 decimal places?
Posted: Sun Jun 05, 2011 5:38 am
by Duftwone
I would like to set a column so that when I enter a number, it automatically shows 2 decimal places -- i.e. typing "8" will show "8.00", and typing ".8" it will show ".80". Thanks in advance for your help.
Re: Setting a column @ 2 decimal places?
Posted: Sun Jun 05, 2011 5:41 am
by thomasjk
Highlight the entire column by clicking at the top. Then use Format-->Cells-->Numbers set the number of decimal places under options.
Re: Setting a column @ 2 decimal places?
Posted: Sun Jun 05, 2011 9:39 pm
by Duftwone
That worked, thank you very much.