Any excel expert here ?

Page no : 2

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

Control F

Format Cells

Select from Cells

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


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

Is this the way you need that ?


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

is it correct ?


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

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 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

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.

 

 

1 Like


CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 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) (345 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



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

Solution suggested by SHIBU is also Correct.


CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27186 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

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


Ajinkya Gijare (CA ) (255 Points)
Replied 05 December 2012

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


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

Where is Screen Shot Attached



SAGAR (ARTICLED ASSISTANCE) (236 Points)
Replied 07 December 2012

Mr Ayush u Ur self a Expert in Excell

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



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro


Subscribe to the latest topics :

Search Forum: