PC Review


Reply
Thread Tools Rate Thread

Carring formula answer to 4 places?

 
 
W. Wells
Guest
Posts: n/a
 
      3rd Jun 2006
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?


 
Reply With Quote
 
 
 
 
joeu2004@hotmail.com
Guest
Posts: n/a
 
      3rd Jun 2006
W. Wells wrote:
> 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?


On the toolbar, click on Format > Cells > Number. Select
"Number" format with 4 decimal places.

 
Reply With Quote
 
Joseph R. Pottschmidt
Guest
Posts: n/a
 
      3rd Jun 2006
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(E-Mail Removed)]
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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook does not print appointments carring over to other days =?Utf-8?B?RnJhbmsgU2NobG9zc2Vy?= Microsoft Outlook Calendar 0 24th Apr 2007 06:50 PM
i edit a formula (excel) then it displays formula not answer =?Utf-8?B?Y2FpbWFu?= Microsoft Excel Misc 2 9th Sep 2005 02:09 AM
Any other places I can try to find an answer =?Utf-8?B?c2ltbW8=?= Microsoft Powerpoint 6 1st Aug 2005 02:48 AM
Problem with formula using an answer of another cell formula KIMBERLY Microsoft Excel Worksheet Functions 4 23rd Apr 2004 08:15 PM
Carring over totals tammi Microsoft Excel Worksheet Functions 2 22nd Apr 2004 07:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:22 AM.