cancel
Showing results for 
Search instead for 
Did you mean: 

Date issue in Excel.

vijay_b4
Active Contributor
0 Kudos

Hi,

PI delivered an Output file which has Date as 2016/04/05. When the vendor open the file in text pad its showing as 2016/04/05, but when they try to open it through excel its not holding the zero i., 2016/4/5. is there any setting we can make in PI to hold the zeros. The file name is saved as .csv in receiver sftp channel.

Thanks,

Vijay.

Accepted Solutions (0)

Answers (1)

Answers (1)

manoj_khavatkopp
Active Contributor
0 Kudos

Vijay,

When the vendor open the file in text pad its showing as 2016/04/05  you already have your answer here , So the date format sent by PI is as expected its the excel which formats date in such a way try in google to change the date format in excel I dont think PI system can do anything here.

Br,

Manoj

vijay_b4
Active Contributor
0 Kudos

There should be some techniques we can use to hold the zeros in excel too right. example:the user can send date in between quotes, so that we can trick the excel to consider it as text..

Former Member
0 Kudos

Are you using any modules to send the file or FCC?

vijay_b4
Active Contributor
0 Kudos

Its SOAP to SFTP Interface. Any ideas?