Hi, I have exported a spreadsheet with a mixture of data. Some of the cells contain a date and time in the format of 08/08/2023 17:05. When I double-click on them. They are automatically converted to 08/08/2023 17:05:00 and displayed as 08/08/2023 17:05 but in different font and alignment.
Is it possible to create a script to double-click on all cells in the active spreadsheet to get them all into the same format?
I tried to use cell formatting, and that won't work.
Thank you for your help
Is it possible to create a script to double-click on all cells in the active spreadsheet to get them all into the same format?
I tried to use cell formatting, and that won't work.
Thank you for your help