how to remove cr and convert it into - sign i or other data and how to remove dr in Trail Balance or other data in excel sheet

[bkpca]

I want to prepare Automated Finacial Statement in excel using Trail Balance in excel with Amount Dr or Cr. 18988 Dr 16598 Cr generated from accounting software like tally
how to remove cr and convert it into - sign i or other data and how to remove dr in Trail Balance or other data in excel sheet

Please expedite

 

[Kamisato Ayaka]

Try this in Macros and run it

Sub TallyData()
'  Change CR to Negative

Dim rng As Range
Set rng = Selection

For Each cell In rng

If InStr(1, cell.NumberFormat, "Cr") > 0 Then
cell.Value = cell.Value * -1
Else
cell.Value = cell.Value
End If

cell.NumberFormat = "general"

Next

End Sub