Any excel expert here ?

Page no : 2

shibu (Accountant) (325 Points)
Replied 03 December 2012

Control F

Format Cells

Select from Cells

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

Upgrade to CAclubindia Pro. Subscribe Now!

shibu (Accountant) (325 Points)
Replied 03 December 2012

Is this the way you need that ?

shibu (Accountant) (325 Points)
Replied 03 December 2012

is it correct ?

Attached File : 503352 1093984 excel.doc downloaded: 164 times

CA AYUSH AGRAWAL (Kolkata-Pune-Mumbai) (26986 Points)
Replied 03 December 2012

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....

CA. Sandeep Kumawat (CA) (341 Points)
Replied 03 December 2012

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.

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

CA AYUSH AGRAWAL (Kolkata-Pune-Mumbai) (26986 Points)
Replied 03 December 2012

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....

Madhur Pahwa (Service) (32 Points)
Replied 04 December 2012

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

shibu (Accountant) (325 Points)
Replied 04 December 2012

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.

CA. Sandeep Kumawat (CA) (341 Points)
Replied 04 December 2012

do as follow type -1 in a cell copy this apply filter by font color select filtered area now press crt+g -> alt+s (i.e. click of special) select visible cells not right click select paste special select multiply click ok it'll convert selected values to negative values

CA CHETAN GUPTA (CA) (588 Points)
Replied 05 December 2012

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

Upgrade to CAclubindia Pro. Subscribe Now!

CA CHETAN GUPTA (CA) (588 Points)
Replied 05 December 2012

Solution suggested by SHIBU is also Correct.

CA AYUSH AGRAWAL (Kolkata-Pune-Mumbai) (26986 Points)
Replied 05 December 2012

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