Rounding Numbers - Adding numbers in Excel - I want the average

D

dbulak

#1
#1
I am adding numbers in Excel. I want the average, but Excel is rounding the numbers up to the next decimal. I have looked, but I just can't seem to find the fix. Anyone know what to do?
Thanks in advance.
 
GAGEpack - Gage & Calibration Management
Elsmar Forum Sponsor
Jim Wynne

Jim Wynne

Leader
Admin
#2
#2
Re: Rounding numbers

dbulak said:
I am adding numbers in Excel. I want the average, but Excel is rounding the numbers up to the next decimal. I have looked, but I just can't seem to find the fix. Anyone know what to do?
Thanks in advance.
Click to expand...
Highlight the cells in question, right-click and choose Format Cells. Click the Number tab and then choose the number of decimal places you want. Excel always stores numbers in full precision regardless of the number of decimal places displayed. For example, if .1234 is rounded to .12, .1234 is still used in calculations.
 
Last edited:
S

sjared

#3
#3
Re: Rounding numbers

Right click on the cell with the average value. Select Format Cells...which opens a dialog box. On the Number tab, select Number for the category type. There should be a box which allows you to select the number of decimal places to display for that cell.
 
D

Darius

#4
#4
In the Home menu, there is a Number section (normally at the upper-center of the display) where you can change the number of decimals or as is said in the other posts, change the "format" in the combobox on the Number section.
 

Attachments

You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
A Is there an SOP on Rounding Numbers Document Control Systems, Procedures, Forms and Templates 8
M Measurement Unit Rounding Nonconformity - Notified Body Audit Registrars and Notified Bodies 6
R Standard for Rounding Measurements for Labels Other Medical Device Related Standards 9
A Significant Figures and Rounding SOP Document Control Systems, Procedures, Forms and Templates 4
J Rounding at the Gas Pumps Coffee Break and Water Cooler Discussions 27
B Conversion and Rounding Standard for converting metric to english and vice versa Other ISO and International Standards and European Regulations 4
P Rounding Uncertainty to Zero on a Calibration Certificate Measurement Uncertainty (MU) 7
B Rounding Numerical Values Up or Down with respect to the number of Significant Digits Measurement Uncertainty (MU) 9
N Rounding the Numerical Value of the Measurement Uncertainty Measurement Uncertainty (MU) 2
H Rounding up Measurement results - Is it still within specification limits? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 26
D Interesting Discussion Is "rounding" acceptable when measuring parts? Tolerance Limits - What is acceptable? Quality Tools, Improvement and Analysis 72
F 1. Suggest a Gage for Checking Rounding of Gears 2. When to conduct Stability Study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
C Labelling and UDI Requirements - Implications of serial numbers US Medical Device Regulations 1
C Multiple Part Numbers, IMDS RoHS, REACH, ELV, IMDS and Restricted Substances 2
C Requirement to link Quality Manual to ISO 9001 clause numbers? ISO 13485:2016 - Medical Device Quality Management Systems 13
M Proof of distribution - FedEx/UPS tracking numbers Manufacturing and Related Processes 2
D Partial FAI - AS9102 - One single drawing has 10 part numbers AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
I Reissuing documents due to missing version / issue numbers Document Control Systems, Procedures, Forms and Templates 3
JoshuaFroud Serial numbers and labelling when sharing device components ISO 13485:2016 - Medical Device Quality Management Systems 1
B AS9102 - Completing Partial FAI's for Baseline Part Numbers AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
C FDA Medical Device Label Requirements - serial numbers Other US Medical Device Regulations 9
T NAFTA request for form with no part numbers showing Supply Chain Security Management Systems 0
L What are the rules on significance of digits in numbers in IEC/ISO standards? IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
M Quality Policy - Standards and reference numbers ISO 13485:2016 - Medical Device Quality Management Systems 14
M Accept/Reject (Ac/Re) Numbers (ISO 2859-1) Confusion Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Sam Lazzara GS1 introduces Global Model Numbers for Medical Devices Other Medical Device Regulations World-Wide 2
N IVD Lot Numbers and Expiration Dates - 21 CFR 809.10 Other US Medical Device Regulations 3
chris1price What are the Scope Numbers on ISO 13485 Certificates ISO 13485:2016 - Medical Device Quality Management Systems 2
S Where to Find DEV and DFE numbers on FDA Website Other Medical Device and Orthopedic Related Topics 3
T Policy or Good Guidance for a Traceability Decision Tree (Serial and Batch Numbers) Misc. Quality Assurance and Business Systems Related Topics 4
T Can 1 TS 16949 certificate be associated with 2 different Duns numbers IATF 16949 - Automotive Quality Systems Standard 2
T Control numbers for records Document Control Systems, Procedures, Forms and Templates 10
M Lot Numbers of Plastic Disposables in an LDT (laboratory developed test) ISO 13485:2016 - Medical Device Quality Management Systems 6
M Bioburden numbers and ECA gloves 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Document Numbers (Identification) on Forms (AS9100) Document Control Systems, Procedures, Forms and Templates 15
F What is the scope for "Total Numbers of Employees on site" per ISO/TS 16949 ? IATF 16949 - Automotive Quality Systems Standard 4
W Humor in numbers Funny Stuff - Jokes and Humour 4
M Determining c=0 AQL numbers Misc. Quality Assurance and Business Systems Related Topics 3
M Document Identification and Control Numbers ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
Jim Wynne Some Xerox Copiers Randomly Change Numbers in Scans Coffee Break and Water Cooler Discussions 14
R Accurate Quarterly Inventory Turn Numbers Quality Manager and Management Related Issues 3
A Calibration Service Suppliers refuse NIST reference numbers on C of C General Measurement Device and Calibration Topics 21
Q Document Numbers for Same Document but in Different Languages? Document Control Systems, Procedures, Forms and Templates 4
E Must Patent Numbers be Shown on Product Labels? Other Medical Device and Orthopedic Related Topics 18
E RSD (Relative Standard Deviation) Calculation for two series of numbers Statistical Analysis Tools, Techniques and SPC 4
L Product numbers & sources for ASTM D3359 adhesive tape Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
J Do production jigs require tool numbers? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
D What records should have form numbers? Quality Manager and Management Related Issues 6
C Changing Document Names/Control Numbers and Obsoleting Document Control Systems, Procedures, Forms and Templates 5
A FD&C dueling banjos (conflicting section numbers) Other US Medical Device Regulations 6

Similar threads

Top Bottom