hardeep.kanwar
Well-known Member
- Joined
- Aug 13, 2008
- Messages
- 693
Dear All,
I have Account Data with "DR" & "CR" Format
What i Need to Convert "CR" Numbers Into Negative
Is it Possible with Formula
Thanks In Advance
I have Account Data with "DR" & "CR" Format
Excel Workbook | |||
---|---|---|---|
A | |||
1 | Balance | ||
2 | 30.00 Cr | ||
3 | 50.00 Cr | ||
4 | 3500.00 Cr | ||
5 | 50.00 Cr | ||
6 | 3300.00 Cr | ||
7 | 3333.00 Cr | ||
8 | 0.80 Dr | ||
9 | 70.00 Dr | ||
10 | 3500.00 Dr | ||
11 | 3500.00 Dr | ||
12 | 3312.00 Dr | ||
13 | 60.00 Cr | ||
14 | 90.00 Cr | ||
15 | 3200.00 Cr | ||
16 | 84.00 Dr | ||
17 | 15.00 Cr | ||
18 | 3150.00 Cr | ||
Sheet1 |
What i Need to Convert "CR" Numbers Into Negative
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Balance | Expected Result | ||
2 | 30.00 Cr | (300) | ||
3 | 50.00 Cr | (500) | ||
4 | 3500.00 Cr | (3500) | ||
5 | 50.00 Cr | (50) | ||
6 | 3300.00 Cr | (3300) | ||
7 | 3333.00 Cr | (3300) | ||
8 | 0.80 Dr | |||
9 | 70.00 Dr | |||
10 | 3500.00 Dr | |||
11 | 3500.00 Dr | |||
12 | 3312.00 Dr | |||
13 | 60.00 Cr | (600) | ||
14 | 90.00 Cr | (90) | ||
15 | 3200.00 Cr | (3200) | ||
16 | 84.00 Dr | |||
17 | 15.00 Cr | (15) | ||
18 | 3150.00 Cr | (3150) | ||
Sheet1 |
Is it Possible with Formula
Thanks In Advance