Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-03-2010
Member
 
Join Date: Feb 2010
Posts: 678
How to set Data Accuracy in Excel 2007

Hi all,

I am working as a data entry operator in one company. I am using excel sheet to put the data. I have many numeric calculation in excel. I want to accurate data in excel. Can anybody advice me how can i put the accurate data in excel 2007. Thanks in advance.
Reply With Quote
  #2  
Old 13-03-2010
Member
 
Join Date: May 2008
Posts: 3,313
Re: How to set Data Accuracy in Excel 2007

The accuracy of the data can be maintained only when you can use this option.
(1) Click the "Office Button" button image, and then click the "Excel Options."
(2) Click the "Advanced" and then in the "When calculating this workbook" is checked under "will be shown in the accuracy of precision set" check box, and then click "OK."
(3) and then click "OK."
(4) In the worksheet, select format cell.
(5) In the "Start" tab, click the "numbers" next to "Dialog Box Launcher" button image.
(6) In the "Categories" box, click the "digital."
(7) in the "Decimal" box, enter the number of decimal places you want to display.
Reply With Quote
  #3  
Old 13-03-2010
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: How to set Data Accuracy in Excel 2007

I am using Excel 2007, apply in the digital format before the data set "to show the precision of subject" option, you can often prevent the floating-point rounding errors can affect your work. This option will work in the table is set for each value of force shown on the worksheet accuracy. Check and reply
Reply With Quote
  #4  
Old 13-03-2010
Member
 
Join Date: Mar 2009
Posts: 1,585
How to set Data Accuracy in Excel 2007

I am also using "to show the precision of subject" option would have cumulative effects, so that your data over time more and more inaccurate. Are you sure you display only the accuracy of the accuracy of the data can be maintained only when they can use this option. Check and reply.
Reply With Quote
  #5  
Old 13-03-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: How to set Data Accuracy in Excel 2007

Tips to reduce the floating-point arithmetic in order to maximize the impact of the cumulative errors, you can also use the ROUND function to calculate the number rounded up to the required number of decimal places. There also many option is provided by Microsoft office for this. All the best.
__________________
Ram requirement for various OS
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to set Data Accuracy in Excel 2007"
Thread Thread Starter Forum Replies Last Post
Excel 2007 Data Import via Bloomberg YajasK MS Office Support 2 09-02-2012 07:24 PM
Sort Data disabled in Microsoft Excel 2007 Thedevotee Windows Software 4 13-01-2012 05:24 PM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM
Export excel data to Word 2007 Uzair Windows Software 5 25-02-2010 06:31 PM
Retrieve data from Access 2007 to Excel 2007 Markesh Windows Software 3 23-09-2009 08:20 AM


All times are GMT +5.5. The time now is 03:21 AM.