Excel: Numbers not formatting correctly. Unable to add decimals
Posted by TJ on Friday August 12, 2016 @ 12:28 PM
[Tags: excel, tips, accounting]

From time to time I run into an issue where for some reason the default styles in an excel workbook get corrupted and I unable to add or remove decimal places from cells even by using the standard ->Format Cells->Number or Account->Decimal places drop down. I found an easy to resolve this would be to import the spreadsheet into Google Sheets ( https://docs.google.com ). Doing this may remove some intentional formatting but it will also should fix the issue with default styles not working.

In Google Sheets:
Upload from Excel to Google Sheets ->File->Open-> Upload

Export file from Google Sheets to Excel : File->Download As...->Microsoft Excel

Post a Comment:
Security Code Security Code:
Comments with offensive language will be automatically deleted within 24 hours.