How to set Data Accuracy in Excel 2007

[Kaufman]

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.

[Raine]

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.

[Sam.D]

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

[ZeDaX]

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.

[ThoMas321]

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.