Dae format problem in excel

[sadiq tanoli]

, MS EXCEL KI FILES MAIN MUJHE DATE FORMAT IS TARAH USE KARNA HOTA HAI DD/MM/YY (YEHNI PEHLY DATE PHIR MONTH AUR PHIR YEAR) YEH DAILY FORMAT CELL MAIN JA KAR DATE FORMAT CUSTOMIZE KARNA PARHTA HAI,COMPLETE FILE MAIN YEH HI FORMAT USE KARNA HOTA HAI LEKIN NEXT DAY AGAIN FORMAT IS TARAH HO JATA HAI MM/DD/YY. KOI TARIQA BATAIN K PERMANENT FORMAT SET HO JAI
THANK U TO ALL MEMBERS AND ADMIN
SADIQ TANOLI

[Kashif Mehmood1]

ap apny pc ki date and time settings main jayn and wahan py ja k date format ko change karain.

[Syed Hamid Ali]

Go to Control Penal - Regional & Language Option - Regional Option tab - Click Custumize - Date tab - Click to Short Formate date. waha dd-mmm-yyyy wala option click ker do aur apply ker do. ok