#VALUE error when you add text and values in Excel

In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error. In this post i will given some idea for Microsoft Excel Support to slove that type of problems.

Although some functions correctly evaluate cells and ignore text strings, if you add the cells by using arithmetic operators such as addition (+), subtraction (-), multiplication (*), or division (/), an error value may occur.

Do the following for Resolution

Instead of using an individual mathematical operator, use its equivalent worksheet function instead:
SUM (adds)
PRODUCT (multiplies)
QUOTIENT (divides)
For example, if you type the following information in cells A1:A7 of a worksheet

A1: 10
A2: text
A3: 20
A4: =A1+A2+A3
A5: =SUM(A1+A2+A3)
A6: =SUM(A1,A2,A3)
A7: =SUM(A1:A3)


the formulas in cells A4 and A5 return a #VALUE! error; however, cells A6 and A7 return the correct value of 30.

How to use startup folders in Excel

Folders that Excel uses at startup
If you install Excel in the default location, Excel opens files from the following paths:
• In Microsoft Office Excel 2003, the path is C:\Program Files\Microsoft Office\Office11\Xlstart

In Microsoft Office Excel 2007, the path is C:\Program Files\Microsoft Office\Office12\Xlstart
• C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART

In this path, User_name is your logon user name.
• The folder that is specified in the At startup, open all files in box

Note
To find the At startup, open all files in box in Excel 2003, click Options on the Tools menu, and then click the General tab.

To find the At startup, open all files in box in Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Advanced. The At startup, open all files in box is under General.

Accepted file types during Excel startup

You typically use startup folders to load Excel templates and add-ins. You can also use startup folders to load workbooks. When you load the following types of files from a startup folder, the files have the important characteristics that are described in the following list.
Templates
If you save a workbook named Book.xlt, and then put it in a startup folder location, that workbook is the default workbook when you start Excel or open a new workbook.

To use additional templates, you must save them in the following folder:
C:\Program Files\Microsoft Office\Templates\1033
To use the templates in Excel 2003, follow these steps:
1. On the File menu, click New.
2. In the New Workbook task pane, click On my computer under Templates.
3. In the Templates dialog box, double-click the template for the type of workbook that you want to create on the Spreadsheet Solutions tab.

To use the templates in Excel 2007, follow these steps:
1. Click the Microsoft Office Button, and then click New.
2. Under Templates, click Installed Templates.
3. Under Installed Templates, click the template that you want, and then click Create.
Add-ins
Add-ins (.xla files) that you put in a startup folder do not typically appear when you start Excel. The add-ins are loaded in memory. The add-ins run any auto macros.

You can use these add-ins by whatever method the add-in provides (for example, a command on a menu or a button on a toolbar).
Workbooks
Workbooks (.xls files) that you put in a startup folder are loaded and appear when you start Excel, unless the workbook is saved in a hidden state.

New Field button is unavailable in Show Field dialog boxes in Outlook

When you use the Field Chooser or Show Fields options in Microsoft Outlook, the resulting dialog boxes may display the New Field button as dimmed (unavailable), or if available, when you click the New Field button, you may receive the following message:
You do not have permission to add a custom field to the folder. Any field you create will appear only in the current view.

To fix this Outlook problem we have to care on You can only create MAPI folder to which you have sufficient privileges.

How to Access Show Field Option

To access the Show Fields option, on the View menu, point to Current View, point to Customize Current View, and then click Fields.

Note In Outlook 2003, on the View menu, point to Arrange By, point to Current View, click Customize Current View, and then click Fields.

The New Field button is not available for one of the following reasons:

- The current folder is a file system folder. For example, if the folder banner shows that the active folder is My Documents, then the New Field button will be unavailable.

- You do not have sufficient permissions to the selected MAPI folder. If the current folder is a MAPI folder, such as a public folder, you must have sufficient permissions to that folder to allow the creation of fields. Have the folder owner ensure create permission is available to you for the active folder. The folder owner, or another user with sufficient permissions, can access the permission settings for the folder by right-clicking the folder in the Outlook Bar or Folder List, and then clicking Properties on the shortcut menu.

To validate that the New Field button is working properly, follow these steps:

1. Select the Inbox or another MAPI folder to which you know you have sufficient permissions.
2. Right-click a column header and click Field Chooser on the shortcut menu.
3. Confirm that the New Field button is available by clicking the button

Subscript characters are displayed incorrectly when you insert them in Excel 2003 or in Excel 2002

SYMPTOMS
When you insert subscript characters in Microsoft Office Excel 2003 or in Microsoft Excel 2002, the characters are displayed incorrectly. For example, an empty rectangle is displayed when you insert subscript one.

CAUSE
When you insert subscript characters, Excel 2003 and Excel 2002 use the Arial Unicode MS font if one of the following is not installed on the computer:
• An appropriate font, such as MS MIncho or MS Gothic
• Support files for the East Asian languages
The Arial Unicode MS font cannot resolve all characters correctly.

WORKAROUND
To work around this issue, use one of the following methods:

Method 1
Install the MS MIncho font or the MS Gothic font on the computer. To do this, follow these steps:
1. Click Start, click Run, type Fonts, and then click OK.
2. Click Install New Font in the File menu.
3. In the Add Fonts dialog box, locate the font file for the MS MIncho font or for the MS Gothic font, and then click OK.

Method 2
Install the East Asian languages support files. To do this, follow these steps:
1. Click Start, click Run, type Intl.cpl, and then click OK.
2. Click the Languages tab, click the Install files for East Asian languages check box, and then click OK.

APPLIES TO
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition


source spport.microsoft.com