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)

Attached Images

	1.jpg (12.0 KB, 9 views)
	2.jpg (18.6 KB, 11 views)