Custom Date Insertion in Google Spreadsheet: A Step-by-Step Guide |
#4 How to insert custom date in google spreadsheet? | गूगल स्प्रेडशीट में कस्टम दिनांक कैसे डालें?
Steps:
1 Open link on Browser
t.ly/3neo
2 Click for Blank Spreadsheet
3 Move Mouse Cursor in Cell
4 Navigate
Format - Number - Date
OR
Format - Number - Custom Date and time - Scroll Down for Desired options.
5 Apply
AI generated steps:
Step 1: Open Google Spreadsheet
Open your Google Spreadsheet in your preferred web browser and navigate to the desired worksheet.
Step 2: Select the Cell
Click on the cell where you want to insert the custom date. This will activate the cell for editing.
Step 3: Access Format Options
In the toolbar at the top, locate and click on the "Format" menu. A drop-down menu will appear.
Step 4: Choose "Number"
From the "Format" drop-down menu, hover over the "Number" option. This will display a sub-menu with various number formatting options.
Step 5: Select "More Formats"
In the sub-menu, select the "More Formats" option at the bottom. This will open a new window with additional format options.
Step 6: Customize Date Format
In the "More Formats" window, click on the "Custom number format" tab. Here, you can specify your desired format for the custom date.
Step 7: Input Custom Date Format
In the "Custom number format" field, enter the desired format for your custom date using the appropriate placeholders. For example, to display the date as "DD/MM/YYYY", you would enter "dd/mm/yyyy" in the field.
Step 8: Apply the Format
After entering the custom date format, click on the "Apply" button to apply the format to the selected cell.
Step 9: Verify the Custom Date
The cell will now display the custom date format you specified. You can enter the desired date in the cell using the format you defined.
That's it! You have successfully inserted a custom date in Google Spreadsheet. Repeat these steps for any other cells where you want to use the custom date format.