Thread: setting fixed decimals in only one column of worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gered gered is offline
external usenet poster
  
Posts: 1
Default setting fixed decimals in only one column of worksheet
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.
Reply With QuoteReply With Quote