Dear sir, Fantastic, it is working , thanks for the great tip.
Regards, Vinod Benjamin, -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amiyo Biswas Sent: Thursday, 16 October, 2008 12:12 PM To: [email protected] Subject: Re: [AI] About the Excel Date Format. Hello, You can also use the Immediate window in vb editor as a calculator. Put a question mark, then type a calculation, and then press enter key. The result will appear in the next line. Say for an instance, type ? 2+3 and press enter. The result 5 will appear in the next line. It is better than windows calculator because you can review the input. Best regards, Amiyo Biswas. Cell: +91-9433464329 ----- Original Message ----- From: "Amit Bhatt" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, October 16, 2008 10:06 AM Subject: Re: [AI] About the Excel Date Format. > Hello Amiyo, > > Fantastic! > It well works in Office 2003. > > Thanks, > > Amit Bhatt > ----- Original Message ----- > From: "Amiyo Biswas" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, October 15, 2008 9:12 PM > Subject: [AI] About the Excel Date Format. > > > > Hello, > > > > Just out of playfulness, I found out another solution for finding out the > > day of a specific date. > > > > Open any office application like word or excel. > > > > Press alt+f11 to open the visual basic editor. > > > > Pres ctrl+g to access the immediate window. This window lets you test > > code. > > > > Now type in the following code and press enter: > > ? format("28/10/2008", "dddd") > > Tuesday will appear on the next line. > > > > Just remember to put the question sign at the beginning. Alternately, you > > can put the word print instead, as here: > > print format("28/10/2008", "dddd") > > > > Enter the date in mm/dd/yyyy inside the quotes. If you put just ddd, three > > d instead of four d inside the second pair of quotes, it will only print > > Tue and not Tuesday. > > > > Maybe it will work in office 2003. > > > > Best regards, > > Amiyo Biswas. > > Cell: +91-9433464329 > > To unsubscribe send a message to [EMAIL PROTECTED] > > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > > please visit the list home page at > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
