| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Need to sum columns where credit balances are shown as ###CR
I just got a huge trial balance from a client that shows debit amounts as
positive and credit amounts with a "cr" after the number. This makes it impossible to sum! Looks like this... 2,000 5,000CR 3,000 2,000CR How can I convert those CR amounts into negatives (either minus sign or using parentheses). It would take days to convert each one, and the Format function does not work, unless I'm missing a step. Please help ASAP. This is due tomorrow! Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
| Need Budget Template for Bills, expenses, credit card balances wh. | New Users to Excel | |||
| How to link endings balances to beginning balances on different sh | Excel Worksheet Functions | |||
Threaded Mode
