Excel date column format issue

[gt0731]

. when i am trying to read THE DATE column it is giving me error
any help on it would be much appreciated 

Attached is the  screenshot of job

tarting job DebugTime at 14:46 30/10/2018.

[statistics] connecting to socket on port 3446
[statistics] connected
Exception in component tMap_1 (DebugTime)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "0030c00002XGcpHAAT"
	at routines.TalendDate.parseDate(TalendDate.java:898)
	at routines.TalendDate.parseDate(TalendDate.java:842)
	at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:978)
	at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1437)
	at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1286)
Caused by: java.text.ParseException: Unparseable date: "0030c00002XGcpHAAT"
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:884)
	... 4 more
[statistics] disconnected

Job DebugTime ended at 14:46 30/10/2018. [exit code=1]

 Also, attaching exact excel sheet with date column that i want to read here

[Anonymous]

Hello,

From your source file, your string :2017-07-17'T'16:15:38'.000Z'.

What does your expected result look like?

Elaborating your case with an example with input and expected output values will be preferred.

Best regards

Sabrina

[gt0731]

Here is information of Input/output 

Input 

From  source file,  string :2017-07-17'T'16:15:38'.000Z'. but when we click on excel cell it looks like 7/17/2017  4:15:38 PM. 

Here is screenshot for input data 

Output
 Expected output should be  in date type  format  should be in  DATE: yyyy-MM-dd'T'HH:mm:ss'000Z'

[gt0731]

I am getting exception it tells that  internal excel date representation coming numeric 
How to parse numeric  into date type 

Starting job DebugTime at 20:42 02/11/2018.

[statistics] connecting to socket on port 3418

[statistics] connected

Exception in component tMap_1 (DebugTime)

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "42933.67752314815"

at routines.TalendDate.parseDate(TalendDate.java:898)

at routines.TalendDate.parseDate(TalendDate.java:842)

at frog_demo.debugtime_0_1.DebugTime.tFileInputExcel_1Process(DebugTime.java:987)

at frog_demo.debugtime_0_1.DebugTime.runJobInTOS(DebugTime.java:1444)

at frog_demo.debugtime_0_1.DebugTime.main(DebugTime.java:1293)

Caused by: java.text.ParseException: Unparseable date: "42933.67752314815"

at java.text.DateFormat.parse(Unknown Source)

at routines.TalendDate.parseDate(TalendDate.java:884)

... 4 more

[statistics] disconnected

Job DebugTime ended at 20:42 02/11/2018. [exit code=1]

[gt0731]

I have date column in excel, but when I'm reading in my talend application I'm getting value as number

Example

Excel Date

1/1/2013 03:44:55 AM

Am getting as

41275.00

How to convert number to date in TALEND