Recent content by jraju

hi, Thanks for your reply So, what you say, is use any excel of 32 version and the macro will work. Will try. But please say, why the dll file has to be installed in system folder. I have worked with macro files which would prompt , enable macros if you trust the source warning and enabling...

Hi, I do not know macros. There was a excel macro sheet sent for my use. On opening it, I receive compile error. On clicking ok, button, on opening the excel sheet, there are value, name NA errors all thro the workbook. It was a workbook with macros version 97-2003. Elsewhere in the discussion...

Hi, chihiro thanks for the answer. i downloaded the template from this link. The above link gives the idea , but i could not find the same. But i found it here https://templates.office.com/en-us/Family-tree-chart-TM01021967 thanks

Would you elaborate, i do not want any online tool. i want excel

Hi, If it all what you cannot change is the parents and relatives and their relations in this world. I really lack the details on the heriditary details of a family member and his sons daughters , son in law and daughter in law. As we pass on and grow old, we could not remember the heriditary...

Hi, Bruce, The link you mentioned is the exact link i tried with my positions but solution greyed. May be the site wants some perks to solve your problem

Hi, I am glad that some kind of thought on this emerges. Taking that white as top and giving nos 1 to 9, and by giving the numbers up to 54 for each side, could there by some visible solution to try a kind of permutation and combination analysis to do ...

Hi, Is there a simple way to solve the Rubic cube. I know it has edge pieces, and centre pieces and 3 rows and their move are restricted to spin and rotate. Is there a way, excel way, to how to solve the scrambled cube...

Hi, I have informed that the solution given by you has worked. I want to know a little more about the custom formatting of [>1000]mm/dd/yyyy;h:mm AM/PM does. I want to know what this denotes . [>1000]. If person like you say something more about what this means, the users of forum would...

Hi, Luke M, When i tried with separate date and time in A2 it has worked wonderfully. Thank you. Could i expect a reply on what the format you have given is doing.

Since the custom format includes time format, i tried that. When you could format the cells with date and time with excel, i had the doubt, whether excel has some inbuilt function to this one. I found in one of the programs, that it has //separators, and you need to give only the 8 digits, it...

Hi,Luke thank you for informing no function When i enter the formula after i input dates and time , i get num error. What should i input if i have to get the input 12/20/2014 05:35 pm in A2 to get in some other cell? what should i type in a2 to get the date only in...

No, i want to enter the date and excel auto separate the entries to the chosen format in the same cell. Is there any tip or function

Hi, When i format a cell with time or date, i have to format the cell and also has to type manually the / / or -- format for date or : for time. Is there any tip, or function in excel where in it is possible to auto separate the entries according to chosen format. For eg. when i...

No. it is working perfectly. What is the problem i am facing is if you copy the formula and paste it somewhere, it gets the value and not time, so the problem. Now it is sorted out. You have to first select the entire column with custom format time in dd/mm/yyyy h:mm:ss and then enter the...