Google sheet TIMESTAMP script format Time with milliseconds & Date with Day and Month without Year
You can format a timestamp in Google Sheets to display time with milliseconds and date with the day and month without the year using custom number formats. Here's how to do it: 1. Assuming you have a timestamp in cell A1, which you want to format. 2. Select the cell where you want to display the formatted timestamp. 3. Click on "Format" in the top menu. 4. Choose "Number" and then "More Formats." 5. Select "Custom number format." 6. In the "Custom number formats" dialog, enter the following custom format: ``` dd-mmm hh:mm:ss.000 ``` This format will display the day, month (abbreviated), hours, minutes, seconds, and milliseconds. You can adjust it as needed. 7. Click "Apply" to format the cell. The timestamp in the selected cell should now be displayed in the format you specified.