Convert tally exported cr. as (-) negative in excel

Prodip Das (xx) (427 Points)

22 December 2015  

In general tally data(say Trial Balance) exported as Dr. or Cr. in excel. However for reporting purpose often there is requirement to represent Dr. amount as positive and Cr. amount as negative like (-). Is there any formula or technique available which can convert Dr. or Cr. as positive or negative?