Dear All,
Exported tally data in Excel with DR and CR how can i convert this DR (+) and CR (-) Please Help me.
Regards,
Rajnath
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.
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.
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.
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 .
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.
rajnath
(accountant)
(48 Points)
Replied 25 June 2019
Sir,
Its also not working please for your suggestion attached herewith excel
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)
CAclubindia
