I am trying to import data from another system and all of the dates are in the format 3/14/2019
So m/dd/yyyy. (or M/dd/yyyy)
Someone told me I need to add a 0 so it becomes 03/14/2019
If I had a couple of rows and a few columns that might be an option, but I have thousands of rows, dozens of columns, and multiple date and date/time fields. Manual editing is not realistic.
I cannot find a way to do this in Excel or Google Sheets. Changing the format only affects the display of data, not the values.
I will listen to all options, though if a coding solution is required I might need to ask for a little more help.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.