Carring formula answer to 4 places?

  • Thread starter Thread starter W. Wells
  • Start date Start date
W

W. Wells

How can I get my answer to a formula to four places? On some columns it does
it and some only 2 places. What is the difference?
 
W. Wells said:
How can I get my answer to a formula to four places?
On some columns it does it and some only 2 places.
What is the difference?
Click to expand...

On the toolbar, click on Format > Cells > Number. Select
"Number" format with 4 decimal places.
 
You need to select the area that you want to format, and set the
formatting for those cells to be 4 places out or however many you wish.


-----Original Message-----
From: W. Wells [mailto:o[email protected]]
Posted At: Friday, June 02, 2006 4:02 PM
Posted To: microsoft.public.excel
Conversation: Carring formula answer to 4 places?
Subject: Carring formula answer to 4 places?

How can I get my answer to a formula to four places? On some columns it
does
it and some only 2 places. What is the difference?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a Nested Formula what I need? 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
How to list cells from two sheets that has different values in theirneighboring column? 8
Very strange behaviour of VLOOKUP in Excel 2010 4
Horserace Form Revisited 2
Formula nesting with IF statements 2
Excel A CountIF question... I think 2
Excel Excel 2007 won't stop rounding down my formula results! 5

Back
Top