hi i want to change the date format in a manner that excel doesn't support , how can i insert the format i want into custom formatting . let me explain: i have a cell with Gregorian date serial number like "41073" i can set the cell format to date to see "2012/06/13" I also can set the date format to "arabic (aljeria)" in the Locale (Location) combo box and "arabic hijri" in type combo box to see "1433/07/24" . as you can see in here excel converts the calender type from gregorian to arabic hijri in here . the problem is i want to design such a format for "solar hijri" instead of "arabic hijri" i mean i want to see "1391/03/24" instead of these formats .... what should i do?(or where can i search for it?)
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.