Clearing $0.00 in Excel

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Al
Posts: 52
Joined: Fri Apr 28, 2006 12:38 pm

Clearing $0.00 in Excel

Post by Al »

PC v.9
Excel 2003
When I do an Income Statement in Excel format, the headings have a "$0.00" after each. I'd like to do a bulk Search and Replace (with blank), but a Ctrl-F for $0.00 won't find the cell, nor will a Ctrl-F for 0 (It finds too many).

Other than manually selecting them all, does anyone have a suggestion?

Al
First United Church
Salmon Arm, BC

Post Reply