Question about Home & Lifestyle Software

1 Answer

Rounding off numbers

Hello,
I would like to know how to round off an number in microsoft 2007 excel

Example question: select and insert the worksheet function that will round off a number (either rounding up or down) to a specified number of digits.
Thanks,
FPH

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 849 Answers

Check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Posted on Nov 04, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Can you give me the product key of microsoft office 2007


If you do not plan on buying the Microsoft Office, then I suggest you download the free software Called Open Office. . It's is about the same as microsoft office, excel, database, etc.

OpenOffice
.org: The Free, Open Source Office Suite. ... A multiplatform and multilingual office suite and an open-source project. Compatible with all other major office suites, free to download, use,

Just click on the download link below. If you find this information helpful, please rate me. Thanks

http://wwww.openoffice.org

Good Luck.

Apr 03, 2010 | Home & Lifestyle Software

5 Answers

MS Word 2007 (SP1 & 2 installed) / Windows 7 My mouse buttons don't seem to be working in the body of the page. I can't select text or position the cursor. I can select functions from the text menu...


you can go to the following link and follow the steps. It seems to me that you installed the service pack and since then you are facing the problem.

http://blog.taragana.com/index.php/archive/microsoft-office-2007-product-key-free/

in this blog look for
How to Convert Microsoft Office 2007 to Full Versionand follow the steps

Feb 26, 2010 | Microsoft Home & Lifestyle Software

1 Answer

Can you solve please problem with opening Microsoft Office Word 97 - 2003 document, which protected by password. I tryed many options but couldn't find programm to unlock the password and get require info....


u may try this..
To unprotect a Word document that has been locked, read on: With the document open press F11 while holding down shift and alt (Alt-Shift-F11). This should launch the script editor in Word;
Next select the find option (or hit ctl-f), and run a find for the word "password." This should highlight something liket his"32943208";
Delete the letters and numbers between the tags (in the above example this would be the 32943208);
Save the document in the script editor and close the window. You should now be back in your Word document;From the "Tools" pulldown menu, select "unprotect." Your document should now be unprotected....

Oct 28, 2009 | Home & Lifestyle Software

1 Answer

Excel 2007


  1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
  2. In the menu bar, go to Format - Cells
  3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
  4. Deselect the small box tagged Locked
  5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
  6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
  7. In the menu bar, go to Format - Cells
  8. In the popup menu that opens, click on the Protection tab
  9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
  10. Click on OK
  11. In the menu bar, go to Tools - Protection - Protect Sheet
  12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
  13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Jun 25, 2009 | Home & Lifestyle Software

1 Answer

Excel Real-Time


  1. open ur spreadsheet from your files that you want to insert a dynamic date and time
  2. select the cell into which you want to insert the dynamic date and time.
  3. Type "=now()" (ignore quotation marks) into the selected cell.
  4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )
.

Feb 17, 2009 | Microsoft Home & Lifestyle Software

1 Answer

Designing a document in book form and printing in Word 2007


When you select Book fold for your page setup, Microsoft Word prints two pages on one side of the paper. When you fold the paper, it opens like a book. This option is intended for documents that have more than two pages.
1. Set up your document as a booklet.
When you create a booklet, it's best to start with a new, blank document so that you have better control over the placement of text, graphics, and other elements. You can add a book fold to an existing document, but you may have to reposition some elements once the book fold is in place.
A. Start a new, blank document.
B. On the File menu, click Page Setup, and then click the Margins tab.
C. In the Multiple pages list, select Book fold.
If your document is not set to landscape orientation, Microsoft Word sets it to landscape.
D. In the Inside and Outside boxes, type or select the amount of space you want for the inside and outside margins (margin: The blank space outside the printing area on a page.).
If you need even more space along the fold to accommodate binding, type or select the amount of space you want in the Gutter box.
E. In the Sheets per booklet list, select the number of pages you want to include in a single booklet.
If the number of pages in the document exceeds the number of pages you select for a booklet, Word prints the document as multiple booklets.
F. Select any other options you want in the Page Setup dialog box.
G. Add text, graphics, headers or footers (header and footer: A header, which can consist of text or graphics, appears at the top of every page in a section. A footer appears at the bottom of every page. Headers and footers often contain page numbers, chapter titles, dates, and author names.), and other elements to your document as usual.
2. On the File menu, click Print.
3. Set options for printing on both sides of the paper.
If you're using a duplex printer (one that automatically prints on both sides of the paper)
Click Properties, and then set the options you want. If you have a choice of setting the page orientation and duplex options, select landscape orientation, and flip the document on the short edge or short side.
If you aren't using a duplex printer
In the Print dialog box, select the Manual duplex check box. Word will print all of the pages that appear on one side of the paper, and then prompt you to turn the stack over and feed the pages again.
4. Select the page range you want to print.
If you click Current page or Pages, Word prints the page you indicate, plus the three other pages that belong on the same sheet of paper.
If you click Selection, Word prints your selection using the default page layout instead of booklet layout.

Dec 25, 2008 | Home & Lifestyle Software

1 Answer

Copy Report to Excel


Try to highlight the area you want copied and either hit <CTRL> and <C> at the same time or left click on the mouse and select copy. Go to the document you want copied and hit <CTRL> and <V> at the same time or left click on the mouse and select paste

Dec 20, 2008 | Intuit Quicken 2002 Deluxe (78588)

1 Answer

Microsoft office 2007 Compatibility with 2003


MS 2007 is not compatible with MS 2003....because the program hadn't been created yet when 2003 was released. To rectify the problem, you must use the SAVE AS command in your 2007 and in the box where it says file type, select Excel 2003 spreadsheet. It will then save it to a format that your 2003 Excel can recognize.

Thanks and please take a moment to rate as FixYa. Thank you.

Jul 22, 2008 | Home & Lifestyle Software

1 Answer

Excel


Select the cell or group of cells --> Format --> Cells

Apr 17, 2008 | Home & Lifestyle Software

Not finding what you are looking for?
Home & Lifestyle Software Logo

Related Topics:

418 people viewed this question

Ask a Question

Usually answered in minutes!

Top Home & Lifestyle Software Experts

john smith

Level 2 Expert

366 Answers

Florin

Level 3 Expert

733 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Are you a Home and Lifestyle Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...