Question about Computers & Internet

1 Answer

Excel Spreadsheet - suppressing zeros

Please tell me how to get rid of all the zeros at the end of a formular result in the same column e.g. 1.98745432872000000000000 & 0.4500000000 but still keeping the columns decimial places.

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 34 Answers

Right click, coose the last option, and choose the format you want it to show as.

Currency $1.99
Custom (13 decimal places) 1.987454328720

Posted on Feb 27, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    What is excel

    What is Excel blankxl_250.jpg
    Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

    Dec 15, 2010 | Microsoft Office Excel 2003 for PC

    1 Answer

    I want an formula in excel to find out number of days present per month an perticular worker

    Hello this is Baris,
    Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

    To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

    Lets say Column A is the days of the month.
    Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
    Click on the cell B32 and type the formula
    =count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

    If you provide me more info we may come up with a better solution. Hope this helps :)

    Sep 24, 2009 | Microsoft Excel for PC

    3 Answers

    Transforming birthdates into year codes

    Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

    1) Make sure each column in your spreadsheet has a heading.

    2) Highlight (select) the column of birthdays.

    3) Choose Format from the menu bar.

    4) Choose Cells... from the drop-down menu.

    5) For the "category", choose Custom.

    6) In the "type" box, type yyyy

    7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

    8) Now, highlight the entire table

    9) Then, choose Data from the menu bar

    10) Choose Subtotals... from the drop-down menu

    11) In the "At each change in" box, choose the name of the column with the birth dates

    12) In the "Use function" box, choose Count

    13) Leave all other choices at their defaults

    14) Click OK, and you are done.

    Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

    I hope this helps.

    Aug 02, 2009 | Microsoft Office Excel 2007

    1 Answer

    Percentages in Excel

    No problem, Melinda, I am here to help!

    If I understood correctly, your spreadsheet looks something like this:
    A B C D
    1 Question Yes No Total
    2 Is sky blue? 20 2 22
    3 Is world round? etc.

    In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
    1) click on the cell where you have the division formula
    2) clck on Format in the top menu bar
    3) click on Cells
    4) click on the Number tab (if you're not already there)
    5) click on Percentage in the list of categories
    6) click OK

    To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

    I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

    Good Luck!

    Aug 08, 2008 | Microsoft Excel for PC

    1 Answer

    I need to import data from access into excel where one column go into one worksheet and other into next worksheet

    Acess will only export the data into an Excel spreadsheet with each element of the record going into a sperate column.

    You can record macros to get the data to go where you want it to go on the spreadsheet.

    Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

    2 Answers

    Import data from access into excel where one column go into one worksheet and other into next

    Can't be done.

    Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

    There are two ways to get around it:

    1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

    2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

    Hope that helps you out.

    Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

    2 Answers

    Formular to show number and cell references

    The formula for A1 is: =SUM(B4,B5)
    A2 is: =SUM(C4,C5)
    A3 is: =SUM(A1:A2)

    To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

    Hope this helps.

    Mar 07, 2008 | Microsoft Excel for PC

    1 Answer

    Excel Formula

    Do you simply need to have the formula: = I2 - F2

    Is there a condition that you want to return zero?

    Jan 19, 2008 | Computers & Internet

    2 Answers

    Duplicacy in excel sheet

    Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
    Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

    Drag this formula down column F till the end of your data
    Select the entire data and do an auto filter
    In column F filter the data by Duplicate and delete all these rows
    What remains should be unique data

    Dec 19, 2007 | Computers & Internet

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    69 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18424 Answers

    Doctor PC
    Doctor PC

    Level 3 Expert

    7733 Answers

    David Payne
    David Payne

    Level 3 Expert

    14162 Answers

    Are you a Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides