Hi all!
i have a list where a dates are. i put that list into combo box using combo box input range field. Then i wanted to use Cell link to get chosen date from combo box, but that cell link shows that date wrong. All field for dates list and cell link are formatted in the same way. for example i choose first date from combo box (20.9.2011) i got 1.1.1900 on the cell link cell. is the 1.1.1900 first date in excel? what should i do to get a right date?
linked cell is showing the seqance no of the date you select in combo box
linked cell should be further linked through index function to get correct date
you may upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Here. Any help?
see attatchment
now it works. Thank you !!
Solved*******
Last edited by kojo; 09-28-2011 at 08:53 AM. Reason: SOLVED
Solved*****
It is pleasent that it is working for you
Kindly also read the Forum Rules
which also includes that If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks