Forum Discussion
Formatting Doesn't Work
Yesterday I accidentally dropped a book on my keyboard while working in excel and it completely jacked the formatting on one of my sheets. Weirdly enough, whatever happened, excel didn't recognize i...
NikolinoDE Thank you, I tried that and there was not a custom format. I changed it to General under that Custom Format tab and nothing changed. Interestingly enough, when I copied the column and pasted it into a new sheet, it automatically showed the Accounting format with dollar sign and decimal and such! But when I copied that same column with the correct formatting and pasted it back into the original sheet, all of the formatting was lost and it went back to just the single number.
Here’s how you can do this:
- Select the cells in the Price column that you want to format.
- Right-click on one of the selected cells and choose Format Cells from the context menu.
- In the Format Cells dialog box, select the Number tab.
- In the Category list, select Custom.
- In the Type field, enter "$"#,##0.00.
- Click on OK to apply the custom number format to the selected cells.
This should format the numbers in the Price column to display with a dollar sign and two decimal places.
I hope this helps!