Share via

How to fix Excel that will not allow formatting?

Tony Bailey 0 Reputation points
2025-04-23T23:37:33.15+00:00

My excel file will not allow me to formatting any cells. All cells are acting like text and will not allow any monetary formatting, i.e. accounting or currency formatting.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,869 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alan Chen 0 Reputation points
    2025-04-24T06:58:25.2933333+00:00

    Try to save it as .xml format, then close Excel, then open the .XML file and save it back to a new .xlsx file, then check if the new file can add formats.

    Or open in Google Sheet, and try to save as a new .xlsx file and then check if you can add format.

    0 comments

Your answer

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