Ya finally I have managed a function. Using such funtion Dr. or Cr. amount can be shown as positive or (-) negative. I would like to share here the step by step procedure which may be useful for the forum members.
Step1: Write the function: In excel file contains of Dr. or Cr. figure, please Right Click on any sheet-----> select View Code---> Right Click below the area of VBA project(blank area in left side)--->Click on Insert--->Select Module. Now write the function as follows:
Function CreditDebit(myCell As Range) As Double
Dim strVal As String
Dim myMult As Integer
strVal = myCell.Text
If Right(strVal, 2) = "Cr" Then
myMult = -1
myMult = 1
CreditDebit = myCell.Value * myMult
Close the window
Now the function CreditDebit is ready which will convert Dr or Cr amount as positive or negative
Step2: Now if you write the function as =CreditDebit in any cell refering the cell contain amount with Dr or Cr it will convert the amount as positive or negative.
For example in attached file let you type the function in cell G7 =CreditDebit(B7) from where data to be converted. Here we need to copy the entire data in G7:J33. So select the range from G7:J33-----> Press F2 and CTRL+ENTER, it will copy the function in entire range.
The above function will covert Dr. or Cr. as positive or negative.
Now you can hide column B to E to show the converted data. Or may copy the value of converted data and paste in your desired reporting range.