When it comes to formatting cells in Excel, most users know how to apply basic text and numeric formats. But do you know how to display the required number of decimal places or a certain currency symbol, and how to apply just the right scientific notation or accounting number format? Continue reading
Comments on: How to format cells in Excel (number, text, scientific notation, etc.)
by Svetlana Cheusheva, updated on
Comments page 2. Total comments: 47
how to covert Hijri date to Gregorian date. please give me correct formula for excel 2010. Example : 12/10/1437 output in Gregorian ????
Hello Abas,
Sorry, I don't know how to do this using a formula. Most likely a macro is required. You can try the sample code from this link:
https://www.excelforum.com/excel-programming/572150-gregorian-date-from-hijri.html
Also, you can check out this thread and download a sample workbook with a macro that converts Hijri dates to Gregorian:
https://www.excelforum.com/excel-general/791099-convert-from-hijri-date-to-gregorian.html
i have the vb codes but need sample formula witch is did easy.
Dear,
i try but not working......
any way thanks for cooperation.