'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Cannot Apply Accounting Format to New Cells in Excel Online
Question details
The user is unable to apply or retain the Accounting number format for new cells in a column in Excel Online following a recent update.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Formatting new data entries in a spreadsheet column using the Accounting format.
- Observed behavior
- New cells do not accept the Accounting format. Workarounds like the Format Painter, toggling formats, and removing delimiters fail to resolve the problem.
Before troubleshooting, ensure your browser is fully updated and try clearing your cache and cookies, as web-based formatting issues can often be tied to temporary browser data conflicts.
Test Across Different Browsers and Desktop Excel
Determine if the bug is specific to your current web browser or the Excel Online platform by comparing its behavior elsewhere.
Web applications like Excel Online can sometimes experience rendering or script bugs specific to certain browsers. Testing on a different browser or switching to the desktop app helps isolate the root cause.
Open a different web browser (e.g., Chrome, Edge, Safari, or Firefox) and log into your Excel Online account.
Open the affected workbook and attempt to apply the Accounting format to new cells.
If the issue persists in the browser, click 'Editing' or 'Viewing' on the top ribbon and select 'Open in Desktop App'.
Apply the Accounting format in the desktop application to verify if the issue is strictly limited to the web version.
Create a Sanitized Test Workbook
Isolate the formatting bug by reproducing it in a clean file without sensitive data, which can be safely shared with support.
Switch to WPS Office for Reliable Spreadsheet Formatting
If Excel Online is experiencing bugs with cell formatting, WPS Office offers a highly compatible and stable desktop alternative. Enjoy seamless formatting without unexpected cloud update glitches.
- 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file.
- 3. Apply Accounting Format: Select the cells you want to format, right-click, choose 'Format Cells', and select 'Accounting' under the Number tab.
Frequently Asked Questions
Why is the Format Painter not working in Excel Online?
Web-based applications sometimes experience caching issues or platform bugs after updates. If the Format Painter fails to apply the Accounting format, try clearing your browser cache, using an incognito window, or switching to the desktop app.
What is the difference between Currency and Accounting formats?
The Accounting format aligns the currency symbols and decimal points perfectly in a column for easier reading, whereas the Currency format places the symbol directly next to the number, regardless of alignment.
How do I clear formatting bugs from a specific Excel column?
Select the affected column, navigate to the Home tab, click the 'Clear' button (usually represented by an eraser icon), and select 'Clear Formats'. Then reapply your desired number format to see if the issue is resolved.
Can a browser extension interfere with Excel Online features?
Yes, certain ad blockers, script blockers, or privacy extensions can conflict with web application functionality. Try running Excel Online in a Private or Incognito window with extensions disabled to see if the formatting issue persists.
