how to fix #VALUE!

LOO XIN YI 0 Reputation points
2026-09-24T01:21:11.88+00:00

my formula is typing correct and change to number / accounting , no spaces yet it continue shows error while the same format for other cells is ok

Microsoft 365 and Office | Excel | For home | MacOS
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. satrio wibowo 0 Reputation points
    2026-09-24T01:46:11.1666667+00:00

    If the formula looks correct and the cell format is already set to Number or Accounting, the issue may be related to the value or formula being interpreted differently in that specific cell.

    You can try these steps:

    Check the formula in the Formula Bar and compare it character-by-character with a working cell.

    Press F2, then press Enter to force Excel to recalculate the cell.

    Check whether the cell is formatted as Text before entering the formula. If so, change it to General or Number, then re-enter the formula.

    Try copying the formula from a working cell and adjusting the cell references.

    If the error remains, please provide the exact error message (for example, #VALUE!, #NAME?, or #REF!) and the formula you're using. The specific error code will help identify the cause.

    Was this answer helpful?

    0 comments
  2. Bob Jones AKA CyberTaz MVP 437.8K Reputation points
    2026-09-24T16:24:04.98+00:00

    Contrary to popular misconception, once digits are entered as Text reformatting the cell as Number does not convert the content of the cell. There are several methods you can use:

    • If a red triangle appears in the upper left corner of the selected cell click the adjacent ⚠️ & select Convert to Number, or
    • Select the cell then on the Data tab click the Text to Columns tool & click the Finish button, or
    • Type the number 1 into a blank cell, copy that cel then use Edit> Paste Special – Multiply

    Other methods are available as well.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.