cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to retrive the date from the excel sheet.

SOLVED
Occasional Contributor

Not able to retrive the date from the excel sheet.

Not able to retrive the date from the excel sheet.

 

Excel I am using is professional 2013.

 

When I read a date from excel it is retriving as text hence for date 18/03/2019

it retrives as 43542.  How can can I get it in the date format?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Occasional Contributor

Re: Not able to retrive the date from the excel sheet.

Issue resolved 

I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.

1 REPLY 1
Highlighted
Occasional Contributor

Re: Not able to retrive the date from the excel sheet.

Issue resolved 

I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.

New Here?
Join us and watch the welcome video:
SeptemberNews
Top Kudoed Authors
Join the September Hub-bub to show off, learn and win