License & Subscription Issues

How to Fix Excel Dates Displaying as Numbers (Account Issue)

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to restore normal date formatting in Excel, as dates are currently displaying as raw serial numbers due to being signed in with an unsubscribed Microsoft account.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening and viewing Excel spreadsheets containing date values while signed into a Microsoft account without an active 365 subscription.
Observed behavior: Cell values display as sequential serial numbers instead of standard dates, even though the formula bar accurately reflects the intended date.

Before you start

Verify your current Microsoft login credentials and confirm which account holds your active Microsoft 365 Family or Personal subscription.

Solution 1Recommended

Switch to the Active Microsoft 365 Account

Resolve restricted formatting issues by signing into the Microsoft account that holds the active subscription.

When Excel is signed into an account without an active subscription, it may enter a reduced functionality mode. This can prevent proper formatting from displaying or being applied.

Access Account Settings

Open Excel and click on 'File' in the top-left corner, then select 'Account' from the left-hand menu.

Sign Out of the Wrong Account

Under the User Information section, click 'Sign out' if it currently shows the unsubscribed Microsoft account.

Sign In to the Correct Account

Click 'Sign in' and enter the credentials for the Microsoft 365 Family account associated with the active subscription.

Format Restored: Once the correct account is authenticated, full editing capabilities are restored and dates should automatically display in their correct formats.

Solution 2

Share a Sanitized Sample File for Diagnosis

If switching accounts does not resolve the formatting error, isolate the issue by sharing a sanitized file with support.

Free Microsoft Office alternative

View and Edit Excel Files Freely with WPS Office

Tired of subscription issues locking you out of your own files? WPS Office is a powerful, lightweight, and completely free alternative to Microsoft Office. It allows you to open, edit, and correctly format Excel files without worrying about active subscriptions.

1. Download and Install: Visit the official WPS website to download the free WPS Office suite for your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel (.xlsx) file directly.
3. Edit Without Restrictions: Instantly view correct date formats and edit your data without needing a paid subscription.

Completely free to use without mandatory monthly subscriptions.Highly compatible with Microsoft Excel (.xlsx and .xls) formats.Lightweight software that opens large spreadsheets instantly.Familiar user interface makes migration effortless.

Frequently Asked Questions

Why does Excel turn my dates into 5-digit numbers?

Excel stores dates as sequential serial numbers for calculation purposes (e.g., January 1, 1900, is serial number 1). If a cell loses its date formatting—often due to restricted features from an expired subscription or accidental formatting changes—it will display this underlying raw number.

Can an inactive Microsoft 365 subscription affect cell formatting?

Yes. If your Microsoft 365 subscription is inactive or you are logged into the wrong account, Excel may enter a reduced functionality mode. This restricts features and can prevent you from saving changes or applying correct number and date formats.

How do I check which Microsoft account I am currently using in Excel?

Open your Excel application, click on the 'File' tab, and select 'Account'. Your current logged-in account and its subscription status will be clearly displayed under the 'User Information' and 'Product Information' sections.

Login & Account Issues