HOW TO apply Indian Date Format to dates in Google Sheets

By default, a new Sheet doesn't have Locale set to India. As a result any date added to a cell may not appear in the dd/mm/yyyy format with standard Indian style format of day followed by month. To fix this issue, I found this tip in the Google Docs Forums useful.

In Google Sheets, choose File > Spreadsheet settings and then change Locale to India -

In the spreadsheet where the Indian date format has to be applied select the cell or column and apply custom Date format for India. Selecting Format from the menu, then choose the following options from Number > More Formats > More date and time formats. Apply the format (or a similar variation) as shown below -

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)