Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Any excel expert here ?

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)

01 December 2012

Dear Excel Expert,

I am Attaching here Excel Sheet, Which is Directly exported from Tally, I have Written the All Details in Excel, pls Try to solve this..

Reply
Follow
Share

37 Replies

CA Manish (Job) (5264 Points)
Replied 01 December 2012

If you press f2 key on the cell then the dr is disappearing. The data is in number format only if dr is written then it will be in text format then only it can be searched.

Upgrade to CAclubindia Pro. Subscribe Now!

CA Manish (Job) (5264 Points)
Replied 01 December 2012

You can change Dr with Cr with the help of custom tab in format Cells.

CA.Ankur Khandelwal (Owner) (281 Points)
Replied 01 December 2012

Select All Cell then Ctrl+H then find Dr. then replace with blank

ANAND S (student) (162 Points)
Replied 01 December 2012

in this exported excel dr. cr was not actually there it shows because of format so copy all datas and paste in notepad and save in desktop and open new excel and go to data tab and click from text and select the notepad file it ask some option give next and finish as with default selection then you can easily can do search because dr. cr. in formating here come actually

2 Like

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 03 December 2012

If you check cell format it is either ""0.000" Cr" or ""0.000" Dr" because of which you are able to see Dr or Cr.

This is problem with file exported through TALLY software.

To avoid this you have to export file in HTML format so Dr. & Cr. will remain in cell.

Other solution are also available.

Thanks//Vaibhav

Revert for more clarity.

Use thank button to convey your appreciation.

Upgrade to CAclubindia Pro. Subscribe Now!

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 03 December 2012

Originally posted by : CA.Ankur Khandelwal
	Select All Cell then Ctrl+H then find Dr. then replace with blank

hi this will not work..

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)
Replied 03 December 2012

as we r able to see dr and cr, but when i press f2 in that cell, then dr/cr disappears...

that only i m asking how to make visible when we press f2

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 03 December 2012

As i said earlier you have to re-export file in HTML format. If you will export in excel format same problem will occur.

Thanks//Vaibhav

Revert for more clarity.

Use thank button to convey your appreciation.

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)
Replied 03 December 2012

when we export in html format then we r nt able to modify i mean to say i wanna in excel format only.......

and by the way

Thanks//Vaibhav

Revert for more clarity.

Use thank button to convey your

appreciation.???

what is this ?

CA Manish (Job) (5264 Points)
Replied 03 December 2012

Originally posted by : ANAND S
	in this exported excel dr. cr was not actually there it shows because of format so copy all datas and paste in notepad and save in desktop and open new excel and go to data tab and click from text and select the notepad file it ask some option give next and finish as with default selection then you can easily can do search because dr. cr. in formating here come actually

Ayush this method is working.

Upgrade to CAclubindia Pro. Subscribe Now!

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)
Replied 03 December 2012

Originally posted by : ANAND S
	in this exported excel dr. cr was not actually there it shows because of format so copy all datas and paste in notepad and save in desktop and open new excel and go to data tab and click from text and select the notepad file it ask some option give next and finish as with default selection then you can easily can do search because dr. cr. in formating here come actually

Yes, Manish Only This is Working...

This is Layman Style but its working.....

Thanks Anand for this......

1 Like

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 03 December 2012

See 3 forum rules..

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 Points)
Replied 03 December 2012

Originally posted by : @ VaibhavJ
	See 3 forum rules..

Dear Vaibhav,

Pls Dont Take it Otherwise, I Was Just Kidding.

I Mean to Say You Dont Need to Write it Every Time, Because One Who is Posting/Replying Here, Will Also able to Read the same Since You also Read.

and if You Think That Only If You Write Then One Will Read Carefully, That is Your misconception, Beacuse He/She Also able to read The Same When They Reply as Caclubindia shows the same message to every one including u and me .....

So You Dont Need to Write it in Your each and Every Reply.

This is Just My thought What i Think so....

and rest is Your Wish, Its also not seem good...

Regards,

CA Ayush Agrawal