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.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    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.


Like:
Currency $1.99
Custom (13 decimal places) 1.987454328720

Posted on Feb 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

I want to recover an excel password


You can use Excel Password, for fast result then use online decryption.

Aug 01, 2011 | Computers & Internet

2 Answers

How to convert excel 2007 to 2003


With Excel 2007, open the spreadsheet.
Click File
Click Save As
Choose to save the file in the "Excel 2003" format.
Choose a filename.
Click Save.

Aug 19, 2010 | ScanSoft PDF Converter Professional...

1 Answer

I have an assignment where 4 worksheets were provided. I did autosum for the total amounts on each sheet. I need to make a summary sheet now to add all of those totals What formula and steps do I take? ...


I'd say you need to pay better attention to the Excel or other spreadsheet books and help you have handy, and categorize your problem according to the behavior you get inconsistent with the suggested solutions already available.

No excuse for your laziness!

Nov 13, 2009 | Computers & Internet

1 Answer

Excel formulas


Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

4 Answers

Excel password recovery


There are several " free " or Trial softwares available to clear the password from excel files, your best bet is to make a copy / backup of the original, and try your luck at either guessing, or using one of the multitude of free software's available to get the document unlocked.

You can do a simple google search, or search CNET.com for related softwares.

May 30, 2009 | AccessData Password Recovery Tool Kit (ftk...

1 Answer

Have Microsoft Windows XP.....purchased HP Officejet J5780 all in


Before you print, look at the print preview. If it shows your document, then the problem is with the printer. If the page is shown blank, the problem is different. Check your Print dialogue screen (File menu, then Print to see the dialogue screen) . have a look what you have selected under the item Page Range. I believe you have clicked SELECTION without actually selecting anything on the document.If that is the case, undo it by clicking on another option
Best of luck


May 26, 2009 | Computers & Internet

1 Answer

How to convert numericals in to words.


You will have to delve into some Visual Basic within Excel:

See this KB article from MS:

http://support.microsoft.com/kb/213360

Oct 22, 2007 | Computers & Internet

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

Related Topics:

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98796 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

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

Answer questions

Manuals & User Guides

Loading...