It is more better to change the tally configration from configuration--Numeric Symbols
Vishal Mohnani
(-)
(25 Points)
Replied 31 October 2018
It is more better to change the tally configration from configuration--Numeric Symbols
Ravishankar
(Partner)
(24 Points)
Replied 04 December 2018
From gateway of tally, go to f12 (Configuration) - Numeric Symbols
Symbols to use for Debit account > Symbol before number (prefix) : Change from blank to (+) and
Symbols to use for Debit account > Symbol after number (suffix) : Change from '_Dr' to blank and
Symbols to use for Credit account > Symbol before number (prefix) : Change from blank to (-) and
Symbols to use for Credit account > Symbol after number (suffix) : Change from '_Cr' to blank.
Close tally restart and export (even in display you get +/- instead of Dr/Cr
sageena
(Article)
(22 Points)
Replied 17 December 2018
Thanks Vishwal... for your Best one suggestions.
Tarun
(CA)
(22 Points)
Replied 13 April 2019
Brilliant Prateek.
Such a wonderful Solution.
you kept the trust of CA degree, although I know it is not matter of degree, but I am happy that a CA knowing the exact pain area of client and resolution.
Thanks
CA. Nitin Mahajan
(Chartered Accountant / Finance Professional)
(45 Points)
Replied 05 November 2019
That's the easiest and simplest way - did the trick for me. I just had to paste to word and then paste back to excel. Witty solution.
Saket Agarwal
(Chartered Accountant)
(274 Points)
Replied 08 January 2020
Imagine the values are in Column A. Filter column A for Cr. Go to column B and enter the formula =A1 * -1. Copy this formula and paste in the entire visible area of column B.
In column A filter for Dr. Now in column B enter the formula to get the positive figures from column A.
This way in column B we will have the converted figures. Now copy paste the values in column B and replace them with the values in column A.
Mukund Trivedi
(Account Professional)
(22 Points)
Replied 28 August 2020
IN VBA You can copy paste following code
all credit will be converted to debit balance
Sub posneg()
Dim myCell As Range
Set W = Application.Selection
'Set W = Application.InputBox("Select one range that you want to change positive to negative:", "ChangePositiveToNegative", W.Address, Type:=8)
Set W = W.SpecialCells(xlCellTypeConstants, xlNumbers)
For Each myCell In W
xValue = myCell.Value
yFormat = myCell.NumberFormat
If xValue > 0 And yFormat = """""0.00"" Cr""" Then
myCell.Value = xValue * -1
myCell.NumberFormat = "General"
End If
Next
End Sub
Dave Shunmugam
(2 Points)
Replied 10 March 2021
Hi, you are able to change the F12 configuration in Tally so that it exports reports as negative or positive which can be used in calculations.
Gateway of Tally - F12 Configure - Numeric Symbols
Change Symbol for Credit amount" And "Symbol for Debit Amount" to "-" and "+" accordingly.
Alim
(Service)
(24 Points)
Replied 15 January 2022
Mr. Prateek!!
Thanks for an easy way to separate Debit/Credit numbers..
V P Narasimhan
(Accounts Manager)
(793 Points)
Replied 17 January 2022
Dear All
Can we filter Cr. first & colour it as Red & proceed further with modification as per our requirements.
Naresh Tandon
(4 Points)
Replied 09 May 2022
Select the entire excel sheet
Use search and replace function to search Cr and replace it with just entering the enter/ return button ie nothing
Multiply the entire sheet with -1 by using paste special function All credit balance will become as -ve numbers whereas Dr one will remain as it is .
Again use search and replace function and find Dr and replace it with blank enter button. All debit balance will now be positive numbers
Thats it .
Naresh Tandon
(4 Points)
Replied 09 May 2022
Select the entire excel sheet
Use search and replace function to search Cr and replace it with just entering the enter/ return button ie nothing
Multiply the entire sheet with -1 by using paste special function All credit balance will become as -ve numbers whereas Dr one will remain as it is .
Again use search and replace function and find Dr and replace it with blank enter button. All debit balance will now be positive numbers
Thats it .
PF & ESI Course - Labour Code 2019 Along with Examples and Case Studies