The Elsmar Cove Business Systems and Standards Discussion Forums Rounding Numbers - Adding numbers in Excel - I want the average
 Forum User Name Keep Me Logged In Password
 Register Photo Albums Blogs FAQ Social Groups Calendar Search Today's Posts Mark Forums Read

 Elsmar Cove Forum Visitor Notice(s) It is the start of the Memorial Day holiday weekend in the US so activity in the forum will be slow through the weekend. Since Memorial Day is observed on Monday I expect activity here to be slow through the weekend and on Memorial Day.

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

 Elsmar XML RSS Feed Monitor the Elsmar Forum Sponsor Links Courtesy Quick Links Links that Cove visitors will find useful in your quest for knowledge: International Standards Bodies - World Wide Standards Bodies International Standards Organization - ISO Standards and Information Quality Digest

Post Number #1
13th April 2012, 12:56 PM
 dbulak Total Posts: 291
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?

Post Number #2
13th April 2012, 01:06 PM
 Jim Wynne Total Posts: 14,159
Re: Rounding numbers

Quote:
 In Reply to Parent Post by dbulak 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!
Post Number #3
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
18th April 2012, 08:34 AM
 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
 decimals.bmp (139.4 KB, 22 views)

 The Elsmar Cove Business Systems and Standards Discussion Forums Rounding Numbers - Adding numbers in Excel - I want the average

 Bookmarks

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

 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 Emoticons are On [IMG] code is On HTML code is Off Forum Rules

 Similar Discussion Threads Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote mr.mike Other Medical Device Related Standards 3 10th September 2012 08:17 PM M Greenaway Excel .xls Spreadsheet Templates and Tools 26 11th November 2009 10:20 AM apestate Document Control Systems, Procedures, Forms and Templates 6 30th March 2006 04:46 AM Bryon C Simmons APQP and PPAP 18 15th August 2002 09:24 AM Aaron Lupo Document Control Systems, Procedures, Forms and Templates 8 24th January 2001 03:40 PM

The time now is 03:28 PM. All times are GMT -4.

 The Deming PDCA Cycle Implementing A Quality Management System FMEA Information APQP Information Auditing Information 8-D Problem Solving Statistics Error Proofing (Poka Yoke) Brainstorming Identifying Waste Pull Systems Lead Time Reduction Planned Maintenance Quick Setup Discovering Change Process Capability - Cp vs. Cpk Histogram Animation Process Loop Animation Taguchi Loss Function Fishbone / Cause and Effects Animation Cove Forum Sitemaps More Free Elsmar Files