Difficulty copying formula @Debraj

[UNAB]

Hi Deb - I hope I am allowed to put your name in the title - if not good - let me know.


Please see the attached - I changed the names for confidentiality. I seem to

not be able to copy the array, not sure what I am doing wrong, but I am doing something wrong. I keep getting "can not copy array".


http://my.rapidshare.com/UNAB/12387


Thank you for looking at this!!!!


Kindly,

Una

 

[Debraj]

Hi Una,


* Thanks for believing in me.. but believe me.. if you assign some-one's name..

** Some good HAPPY TO HELP hand will leave them due to love and respect for each other.

* If you doesn't POINT someone.. then I believe.. someone will sure help you on my behalf..


Now regarding your problem.

* I think, Its not about copying formula.. its may be something else..

* Every time.. I change your DATE from mm-dd-yyyy format to dd-mm-yyyy by assuming its my system's default setting which converting it to TEXT.


@ UNA:

* Please select C9:C273

* Data > Text to Column > NEXT > NEXT > Column Data Format > DATE > MDY > Next > Finish

* Same for Column D..


@ Happy to Help Hands..

* Can someone please check.. if your system also taking Column C & D as TEXT..


Regards,

Deb

 

[inbp]

@ Deb Bhai how are you.


You are right, your method is working correctly


Thanks

Muhammad Shakeel

 

[Debraj]

Hi shakeel!


Fine and thanks

But I am expecting answer from some other country member whose system's default date format is MMDDYYYY..

And you are my brother from same country... and I guess yours date format is same as mine..


Isn't it!!


Regards

Deb

 

[UNAB]

Hi Deb and Shakeel -


It is definately in the format of the date. I formated my date your way and it WORKS!!!!!


Thanks so much.

Una (very happy))))))

 

[inbp]

yes my format is same till today afternoon, today my boss change defualt date formte