Share via

Excel will not display currency in spreadsheet

Anonymous
2019-12-30T16:29:35+00:00

When I format a cell as currency (using UK £), the cell goes blank.  The value is still displayed in the Formula Bar but not in the cell.

However, if the amount is negative e.g. -£1,000, it does display in the cell.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-12-31T12:55:57+00:00

    Thanks for all the help.

    I rolled back to build #16.32 which has solved the problem for the time being.

    I will wait and see what #16.34 brings.

    Happy New Year to you all.

    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-12-31T08:13:19+00:00

    I am experiencing what I believe is a related problem. Beginning with build 19122904, certain special characters do not display despite being in the formula bar. Some examples include the en dash (–) and em dash (—). This happens with new and existing workbooks. When I view the same workbooks in Excel for iOS, the characters display properly.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2019-12-31T12:21:20+00:00

    When I format a cell as currency (using UK £), the cell goes blank.  The value is still displayed in the Formula Bar but not in the cell.

    However, if the amount is negative e.g. -£1,000, it does display in the cell.

    Hi, I have the same problem in my iMac 2017 Catalina 10.15.2.

    Today  update #16.33.19122904 doesn't resolve it. I have a copy of Excel #16.33.19121804 that display the correct numbers in currency columns.

    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2019-12-31T18:32:44+00:00

    Hi

    You folks are using Insider Fast builds of Office.

    It is very important to post questions and comments about Insider builds in the Insider Forum. You've posted to the general release forum. The support folks here do not know about what 's going on with Insider builds.

    For this reason I am locking this question thread. Please repost this issue inthe Insider forum so that the Microsoft folks working on Insider builds will learn of the issue. It is also critical to report anomalies using the Smile button in the upper right corner of the Excel window when using Insider builds

    Thanks

    0 comments