Changing date from decimals to date format

Help Activities
1

Hi all,
I have excel file and i need to do some filtering part, after filtering i am writing that excel file but in that one of the date column is coming as decimals, i need to change decimals to date format.

Is that possible. Can anyone help me.
Thanks in advance

2

Can you please share any example of it

3

I am sorry my time column is coming as decimal like 0.98734 i want to change this to time

4

Hi @hanviprebday

Can you give a try the following?
image
image

TimeSpan.FromDays(CDbl(strInput)).ToString

Regards

5

Thanks a lot it worked

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.