FastTips: "Basic Use Questions and Answers" (WE1208)

• Microsoft Excel for Windows 95, version 7.0

This article contains the text of "WE1208: Basic Use Questions and Answers," which is available on the Microsoft FastTips service for Desktop Applications. To access this service, call (800) 936-4100.

You can obtain this Application Note from the following sources:

• Microsoft's World Wide Web Site on the Internet
• The Internet (Microsoft anonymous ftp server)
• The Microsoft Network (MSN)
• Microsoft Download Service (MSDL)
• Microsoft FastTips Technical Library
• Microsoft Product Support Services

THE TEXT OF WE1208

  Microsoft(R) Product Support Services Application Note (Text File)
                WE1208: BASIC USE QUESTIONS AND ANSWERS

                                                   Revision Date: 8/95
                                                      No Disk Included

 INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY
 ACCOMPANY THIS DOCUMENT (collectively referred to as an Application
 Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
 EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR
 PURPOSE. The user assumes the entire risk as to the accuracy and
 the use of this Application Note. This Application Note may be
 copied and distributed subject to the following conditions:  1) All
 text must be copied without modification and all pages must be
 included;  2) If software is included, all files on the disk(s)
 must be copied without modification (the MS-DOS(R)  utility
 diskcopy is appropriate for this purpose);  3) All components of
 this Application Note must be distributed together;  and  4) This
 Application Note may not be distributed for profit.

 Copyright (C) 1995 Microsoft Corporation.  All Rights Reserved.
 Microsoft, MS-DOS, Visual Basic, and Windows are registered
 trademarks and Windows NT is a trademark of Microsoft Corporation.

1. Q. Why can't I run Microsoft Excel version 5.0 for Windows NT(TM)
      and Microsoft Excel for Windows 95 on the same computer?

   A. Due to internal differences in the 32-bit Visual Basic(R) for
      Applications library files needed to run these two versions of
      Microsoft Excel, it is not possible for both versions of
      Microsoft Excel to reside on the same computer. For more
      information about this issue, please order item number Q131299
      from the FastTips Catalog.

2. Q. Why do files that I created in Microsoft Excel version 5.0
      increase in size by 4-6K when I open them in Microsoft Excel
      for Windows 95? This happens even if I add no additional
      information to the file.

   A. This behavior occurs in part because Microsoft Excel for
      Windows 95 has been optimized to save files faster than
      Microsoft Excel version 5.0. Note, also, that when you create
      and save a file in Microsoft Excel for Windows 95, the file is
      not necessarily larger than the equivalent file that you create
      and save in Microsoft Excel version 5.0. For more information
      about this issue, please order item number Q132454 from the
      FastTips Catalog.

3. Q. When I try to use zip codes to create a map object in Microsoft
      Data Map, I receive an error message. Why is this happening?

   A. When you create a map object based on zip codes, you must
      format the zip codes with the special Zip Code number format.
      For more information about formatting cells with the Zip Code
      format, please order item number Q131929 from the FastTips
      Catalog.

4. Q. In versions of Microsoft Excel earlier than version 7.0, when I
      type a value with a percent sign or format a value with a
      Percentage number format, the value is displayed in the formula
      bar in decimal format. However, in Microsoft Excel for Windows
      95, when I type a value with a percent sign, the value in the
      formula bar is displayed with the percent sign. Why does this
      happen?

   A. This new behavior makes it easier for you to enter a new value
      in a cell that is formatted with the Percentage number format.
      For example, in earlier versions of Microsoft Excel, when you
      enter the value 0.41 on your worksheet and format the cell with
      the Percentage number format, the value is displayed as 41%. If
      you then enter the value 56 in that same cell, the value is
      displayed as 5600%, instead of 56% as you may have intended.
      For more information about this issue, order item number
      Q129253 from the FastTips Catalog.

5. Q. Why are my Microsoft Excel documents being saved in the "My
      Documents" folder?

   A. By default, all Microsoft Office applications are saved in the
      "My Documents" folder. To change the default directory for
      Microsoft Excel, use the following three steps:

      1. In Microsoft Excel, on the Tools menu, click Options.

      2. Click the General tab.

      3. In the Default File Location box, type the path to the new
         default directory.

TO OBTAIN THIS APPLICATION NOTE

The following file(s) are available for download from the Microsoft Software Library:

 ~ WE1208.EXE (size: 14994 bytes) 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

If you are unable to access the source(s) listed above, you can have this Application Note mailed or faxed to you by calling Microsoft Product Support Services Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7070. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, see the Microsoft World Wide Offices Web site at:

   http://www.microsoft.com/worldwide/default.htm