Reference number: CH000777

Getting #NAME? when entering data into Microsoft Excel.

Question:

Getting #NAME? when entering data into Microsoft Excel.

Cause:

Error with formula or data in cell.

Answer:

Often, this issue is caused when attempting to enter data in a cell that Microsoft Excel interprets as a formula instead of plaintext. If you're entering data that you want to be interpreted as plaintext, enter a single quote (') at the beginning of the text, as shown below.

'====end====

If you're getting this value in a cell that you're entering a formula in, verify that the formula is formatted properly and that the cells being referenced in the formula are correct. For example, in the below formula, the cell "BAa1" is not a valid cell and will cause this error.

=(A1+BAa1)

Finally, make sure you're if you're using a version of Excel that is non-English version that you're using the correct commands for formulas. For example, =sum is  =som in some other language versions.