Thread: cell formated to 2 decimal places but excel shows it as 4 need 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default cell formated to 2 decimal places but excel shows it as 4 need 2
Formatting just changes the display of the number but does not change the
underlying value which can be many decimal places.

You can use the ROUND function in your calculations.

=ROUND(SUM(F1:F2),2)

Alternative is to go to ToolsOptionsCalculation and check "Precision as
displayed".

Note: this will permanently change all numbers on the sheet to displayed
values.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 11:18:02 -0800, b jones <b
wrote:

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