×
英语
很抱歉。本文没有你的语言版本。

Wrong Japanese Era displayed in Excel dates

Last Updated: June 6, 2018

ISSUE

When typing a date into Excel, sometimes the wrong era for Japanese reign is displayed in the calendar. Dates in Gregorian format are not affected. Formulas are also not impacted.

This issue is on build 16.0.9330.2087.

STATUS: WORKAROUND

Our engineering team is working on a fix. In the meantime, you can uncheck "Input dates according to selected calendar" when using Japanese reign calendar.

Alternatively, you can delete the following registry key

  1. Right-click the Start menu and type regedit and press Enter

  2. Navigate to the following location:
    Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\Calendars\Japanese\Eras

  3. Click on the key with the name 2019 05 01 and press Delete

  4. Confirm the deletion by clicking Yes

Close the Registry Editor and restart Excel

Eras

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Excel UserVoice

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×