Date formatting
Formatting Problems:
1. I have a date field E.g.: January 02, 2011 and i want this Date formatted into 01/02/2011. and when i format the fields using mm/dd/yyyy it gives the exact result. but, when i take this to another program or if i compare it with another excel sheet. the date field is shown as 1/2/2011
2. In another field i need same kind of date format to be converted to Jan-11 (Mmm-yy) but when compared this too gives similar result(1/2/2011) and my comparison shows ERRORS.
is there any way i can solve this.
can i make this permanent or static or something like dat so that it will remain permanent to the format i specify.
Rgds
Xavier
(Note: please check with the fields "D" and "AD" in the attached file)
|