FG
💻 Software

Excel repeatedly changes cell number format to Text

Fresh7 days ago
Mar 15, 202632789 views
Confidence Score0%
0%

Problem

I've used Excel more than I care to think about, but this is a new one for me. I have a cell with a simple formula, . I set the number format to General. I edit the cell (just F2-Enter, no change). The formula no longer works, and when I check the number format, it's now Text. Has anyone else seen …

Error Output

=Counts!E3

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel repeatedly changes cell number format to Text

Low Risk

You need to set the format to Number. General means Excel is going to guess, and thus change the format on its own. This is usually more apparent when you enter in Dates/Time. Best that you go ahead and explicitly change it if this happens again.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment