Question about Home & Lifestyle Software

1 Answer

Excel on entering a number to a cell the number is automatically given to decimal places. it happens anywhere on he sheet. Ive tried a number of fixes wth no sucess help I believe the problem is elsewhere

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 73 Answers

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

Posted on Oct 30, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

What is my unluck code?


There are restrictions for the Code,
Hope the llink below can help you. Good Luck :0)

http://web.intuit.com/support/quicken/service/unlock/6273.html

you may obtain another unlocking code or a Quicken CD using one of three options:
  • Online Unlock Tool option (Available for 2003, 2002, and 2001): To unlock your version of Quicken online, please click here and follow the directions on the screen to generate a new unlock code. Please be at your computer with Quicken open and the serial number displayed. (Do not write down the serial number and close the program before using the Unlock Tool, as a different serial number will generate each time the program is opened). Our Unlock Tool will check for your previous unlock and issue a new unlock code, free of charge.

  • Online Unlocking Option (Available for 2005 and 2004): To unlock again online, you will need your order number for reference. You will also need to have the Quicken 2004 or 2005 CD in the CD-ROM drive while walking through the unlock process. (Note: You do not need the CD for the New User Edition). Launch the version of Quicken currently installed on your computer. Once launched, go to the help menu and then to the Unlock again option. If you have your Unlock code from either your conformation e-mail or from the Order Status window you can enter it in the blank field. If you do not have the Unlock code, select Go online to automatically unlock Quicken. Quicken will then connect to the Shop Intuit Web site. Enter your Shop Intuit member ID and password. In the Order History window, enter your unlock order and click View. In the Order Details window, click Unlock Code. Close the Shop Intuit Web site. Restart Quicken to begin using your new features.

  • Live Chat option (Available for 2005, 2004, and 2003): To request a new unlocking code, contact Quicken Chat (5:00 A.M. - 5:00 P.M., Pacific time, Monday - Friday and 7:00 A.M. - 7:00 P.M., Pacific time, Saturday - Sunday) Please be at your computer with Quicken open and the serial number displayed. (Do not write down the serial number and close the program before chatting, as a different serial number will generate each time the program is opened). Our Quicken Chat Representative will research your account to locate your previous purchase and issue a new unlocking code, free of charge.

  • Telephone option (Available for 2005, 2004, and 2003): To request a new unlocking code, call Quicken Sales and Service at (800) 811-8766 (5:00 A.M. - 5:00 P.M., Pacific time, Monday - Friday) and press "2" for customer service. Please be at your computer with Quicken open and the serial number displayed. (Do not write down the serial number and close the program before calling, as a different serial number will generate each time the program is opened). Our Sales and Service Representative will research your account to locate your previous purchase and issue a new unlocking code, free of charge.
To place an order for the newest edition of Quicken, please visit www.quicken.com. If you have additional questions regarding Quicken 98 or 99, please contact Quicken Sales and Service at (800) 811-8766, 5:00 A.M. to 5:00 P.M. Pacific time, Monday through Friday.

Good Luck.

Nov 07, 2009 | Intuit Quicken 2003 Basic (270902) for PC

1 Answer

How can I download the free MS Word & Excel


Try to download Openoffice, it is free (includes text editor, excel and powerpoint)

Aug 26, 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

2 Answers

I want to put the Latitude n Longitude freqeuncy in google earth for search a eddress any one can tell me how i can do this


Hello

You can use them in Find (Edit -Find).

Format is as follows:

Latitude, Longitude in decimal format 37.7, -122.2

or

Latitude, Longitude in DMS format 37 25'19.07"N, 122 05'06.24"W or
37 25 19.07 N, 122 05 06.24 W

More info here http://earth.google.com/userguide/v4/ug_findplaces.html

Best regards,
Zizzler

Apr 23, 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

Rounding off numbers


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

Nov 04, 2008 | Home & Lifestyle Software

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

Related Topics:

55 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

18304 Answers

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

Answer questions

Manuals & User Guides

Loading...