Select 1st column, Format= Cells=Number with zero decimal places
Repeat for second / third (?) column with 2 decimal places

"gered" wrote:

i want to set 1-2 column's in worksheet to fixed decimals. The only way i
have found is tools-options-edit and set decimal. this changes all future
data for the sheet to be set in this manner. I want to enter quanity x price
= cost. i want quanity without decimals and the other column's with fixed
decimals.