Dear All,
Exported tally data in Excel with DR and CR how can i convert this DR (+) and CR (-) Please Help me.
Regards,
Rajnath
7 Replies
Kumar Sushank
(General Manager - Finance)
(1040 Points)
Replied 22 June 2019
Select the column where Dr & Cr is showing then press Ctrl + H (Replace) then enter in Find what : DR & Replace with : + then Find what : CR & Replace with : -
rajnath
(accountant)
(48 Points)
Replied 22 June 2019
Sir,
Its not working.
Attached File : 1378954 20190622155654 caterpiller over due.xlsx downloaded: 152 times
Kumar Sushank
(General Manager - Finance)
(1040 Points)
Replied 22 June 2019
Please check attached file, You have to select the amount column & right click on mouse then select format cell & choose Number >> Accounting then select 2 decimal then ok. Hope it will be work.
Attached File : 1793680 20190622160258 caterpillar.xlsx downloaded: 168 times
Satya N Dharani
(Finance Professional)
(491 Points)
Replied 22 June 2019
simple solution , change values format to numeric.
revised format also attached for your ready use.
Attached File : 2248805 20190622160923 caterpiller over due.xlsx downloaded: 160 times
rajnath
(accountant)
(48 Points)
Replied 22 June 2019
Sir,
Earlier attachment manually i have changed Cr to negative value i have attached new file could tell me know how to this .
Attached File : 1378954 20190622162025 caterpiller outstanding.xlsx downloaded: 178 times
Satya N Dharani
(Finance Professional)
(491 Points)
Replied 24 June 2019
Pl see enclosed file. 1st select to all values numeric, then put negative values for Cr , after that select values to "custom format" Dr , Cr.
Attached File : 2248805 20190624095312 caterpiller outstanding.xlsx downloaded: 133 times
rajnath
(accountant)
(48 Points)
Replied 25 June 2019
Sir,
Its also not working please for your suggestion attached herewith excel
Attached File : 1378954 20190625141814 ledbills.xlsx downloaded: 194 times
Recent Topics
- Gst tax rate on canned mushroom
- Cash Expense in Corporate Sector
- Sell my 16 year old private limited company
- Gst penalty u/s 122 (1) XII
- Gst penalty u/s 122 (1) XII
- Address in document as Proof of Communication Addr
- Purchase via Commission agents
- GST Clarification on Popcorn
- SECTION 269SU DETAILS REPORTING
- Tds or tcs on foreign remittance to india as a rei
Related Threads
Trending Online Classes
-
6 days Certification Course on GST Practical Return Filing Process
CA Pratibha Goyal16 December 2024
CAclubindia
