The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

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


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links



Courtesy Quick Links

Links that Cove visitors will find useful in your quest for knowledge:


ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Atul's
Quality Forum Online

Howard's
International Quality Services

Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum

Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Related LinkedIn Groups

ISO 9001 for Small Businesses

ISO 9001:2015 Revision Discussions

Information Security Community

Medical Devices Group

Quality and Regulatory Network

FDA (Food and Drugs)

AS91XX Series - Tips and Advice


Related Topic Tags
microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 13th April 2012, 12:56 PM
dbulak's Avatar
dbulak

 
 
Total Posts: 286
Please Help! Rounding Numbers - Adding numbers in Excel - I want the average

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.

Sponsored Links
  Post Number #2  
Old 13th April 2012, 01:06 PM
Jim Wynne's Avatar
Jim Wynne

 
 
Total Posts: 14,149
Re: Rounding numbers

Quote:
In Reply to Parent Post by dbulak View Post

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.
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 by Jim Wynne; 13th April 2012 at 01:52 PM. Reason: Typo
Thank You to Jim Wynne for your informative Post and/or Attachment!
Sponsored Links

  Post Number #3  
Old 13th April 2012, 01:09 PM
sjared

 
 
Total Posts: 27
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.
  Post Number #4  
Old 18th April 2012, 08:34 AM
Darius's Avatar
Darius

 
 
Total Posts: 551
Re: Rounding Numbers - Adding numbers in Excel - I want the average

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.
Attached Images
File Type: bmp decimals.bmp (139.4 KB, 22 views)
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
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


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Systems for Serial Numbers, Batches and Catalogue Numbers mr.mike Other Medical Device Related Standards 3 10th September 2012 08:17 PM
Random 'Normal Distribution' Numbers in Excel M Greenaway Excel .xls Spreadsheet Templates and Tools 26 11th November 2009 10:20 AM
Working with part numbers in assemblies - Is there a standard for part numbers? apestate Documentation Control Systems, Procedures, Forms and Templates 6 30th March 2006 04:46 AM
PPAP Applicability - 10,000 Part Numbers - Control Plans for ALL part numbers? Bryon C Simmons APQP and PPAP 18 15th August 2002 09:24 AM
Is there an SOP on Rounding Numbers Aaron Lupo Documentation Control Systems, Procedures, Forms and Templates 8 24th January 2001 03:40 PM



The time now is 11:51 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 


NOTE: This forum uses "Cookies" -- The Elsmar Cove is *Copyright Free*.
A Peachfarm LLC Internet Property