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.
|
