Hi all, I have a column Date Time that I need to convert later on to String. [dateTeime] As you can see from the screenshot, when I select a particular cell from the Date Time column(35:36.3), in the format field above you can see it’s different - 12:35:36 AM. The first question is why is that h…

Hi May be let’s go one by one Here the format is changing so as the column format in excel That specific excel column has a different format I would suggest to make it as TEXT so that we won’t face this format change issue [image] bp777: The first question is why is that happening? I assume…

How to properly convert Date from excel to String?

Help Activities

pravin_calvin (pravin kumar) October 15, 2021, 11:12am 4

Hi @bp777

Its a of Type OA date format.

refer the thread below!

Regards

1 Like

Topic		Replies	Views
Date Format from Excel Converter Activities excel , activities , question	8	450	July 13, 2023
Change Format in Excel (General to Date) Help	15	6825	September 22, 2019
How to convert excel column (string) to date format Studio	7	3836	June 8, 2022
Date formatting problem Help studio	3	821	January 16, 2021
Date conversion from excel column Help excel , activities	14	2931	September 7, 2019

How to properly convert Date from excel to String?

Related topics