Value In Brief – by Abanoub Hanna
All You Need To Know Explained In Brief

Posts Tagged with Microsoft Excel

How to Convert Arabic Numbers to Hindi Excel

if you want to convert numeric numbers (1234567890) to Arabic numbers (Hindi)(١٢٣٤٥٦٧٨٩٠) select the area of cells that you want to change press ctrl + 1 for format cell go to custom and type this code: [$-2060000]0 Note: Hindi numbers are ١٢٣٤٥٦٧٨٩٠ but we generally call them Arabic numbers which is not correct.

How to Calculate Age in Microsoft Excel

In the cell of age, write this =INT((TODAY()-B2)/365) where B2 is the location of the cell where the date of birth written. This code just caclulate the number of years passed. So you know the age of this person in years. But what if I want to know the months and days too ? To get the age in years, use =DATEDIFF(dateOfBirth, TODAY(), "Y") and replace dateOfBirth by the location of the cell where the birthday are written.