Format numbers and currencies

Standardize the presentation of amounts in the profit-and-loss workbook: format all revenue and cost lines as currency with two decimals, show percentages with one decimal, and display negative numbers in red parentheses. Send the file to Marcus in finance for sign-off on Friday and confirm the totals still match after formatting.

Before I send the financial pack to the CFO, make the monetary formatting clear and reviewable. Move currency formatting into styles, ensure consistent decimal places across comparable columns, make unit labels explicit in the header, and flag any cells with mixed number formats or manual text that will confuse reviewers.

I applied currency formatting to the expense column and several rows now show as left-aligned text, breaking the column total. The CFO will question the pack. I don't know which cells are text masquerading as numbers or whether margins or custom formats caused it. Identify the cells preventing numeric formatting, explain why they broke, and give the fastest repair so totals and alignment are correct for review.

Every close I get pushback: inconsistent decimals, stray currency symbols, and cells formatted as text. I spend an hour per report cleaning formats. Which small formatting standards and checks should I adopt so the pack looks consistent on first pass and reviewers stop flagging trivial format issues?