Any excel expert here ?

Control F

Format Cells

Select from Cells

I have a screen shot, but can`t paste it here

Is this the way you need that ?

is it correct ?

Originally posted by : shibu
	Control F Format Cells Select from Cells I have a screen shot, but can`t paste it here

Thanks.....

I Was Looking for This Kind of Expert Reply Only...........

U and Anand Solved My Problem

My Purpose Has been Solved....

hi

you can do this too.. select by font color and then multiply visible cells by -1 it will convert in negative and positive values for Cr and Dr.

But Sandeep How It Can Convert......

Since Its Not Considering Dr & Cr at any where.....

and how excel will identify that cr is to be negative and dr is to be positive....

just select whole column and then right click choose format number 1234.10 and u will get data in desired format.

Originally posted by : CA AYUSH AGRAWAL
	Thanks..... I Was Looking for This Kind of Expert Reply Only........... U and Anand Solved My Problem My Purpose Has been Solved....

Welcome, Hope your purpose served. Infact those huge data.

Hey if U want to FIND Cells with "Dr." then Just :-

Press Ctrl+F then Expand the OPTIONS in the "Find Dialogue Box"

Then in the "LOOK IN" Option select "VALUES"

It will search all Cells with Dr. or Cr.

/editor_upload/928227507untitled.bmp

Solution suggested by SHIBU is also Correct.

Originally posted by : Chetan Gupta
	Hey if U want to FIND Cells with "Dr." then Just :- Press Ctrl+F then Expand the OPTIONS in the "Find Dialogue Box" Then in the "LOOK IN" Option select "VALUES"   It will search all Cells with Dr. or Cr.   /editor_upload/928227507untitled.bmp

But After Pressing Replace Tab, Its Not Working....

No Method i Actually Perfectly Working, I Mean to say Suggested by u or shibu or anand....

all require some labour....

Please find attached 2 Files ...Screenshots...

You will find answer to ur question in Feature of Ctr + F .."Options"

If it Helps...pls do inform me...

Thank u,,,,

Where is Screen Shot Attached

Mr Ayush u Ur self a Expert in Excell

still u r searching for a export Y ????