Thread: cell formated to 2 decimal places but excel shows it as 4 need 2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
b jones b jones is offline
external usenet poster
  
Posts: 1
Default cell formated to 2 decimal places but excel shows it as 4 need 2
i have the cell formated as 2 decimals but the cell information is in 4 to 5
decimals i.e. 4.3453 need it to be 4.35 to be used for other functions how do
i get the cell in 2 decimals.
Reply With QuoteReply With Quote