Excel time stamp format mismatch

[Ranjeet_Singh]

Hello all, 

                                      I am writing time stamp into an excel file. Time stamp for time 2013 & 2012 appears different although format & method of writing is same in both the cases.

In the attached file below. When time stamp is 2012 then format of time stamp in excel file & in input is same but when time stamp is 2013 then format of time stamp what i am writing actually & what appears in excel file is different.

Dont know where exactly it is going wrong ?

[nathand]

Are you writing to the same Excel file in both cases? If not, is the cell formatting the same for both? It looks like in one case Excel is interpreting the text as a date and time, whereas in the other it's treating it as plain text. Perhaps in the 2012 case you have a stray character somewhere (maybe a trailing space)? What happens when you type exactly same text into the cell in Excel, bypassing LabVIEW? Can you share some code and an Excel file that demonstrates the behavior you're seeing?

[mnx]

Exactly.. check your excel sheet / cell settings...!

[Ranjeet_Singh]

hi nathand,

                             No excel files are different. I should not check cell formatting becasue if in 1 file format is same then in another one also it should be same. Cell formatting is same for both.

I am using 2011

[Ranjeet_Singh]

hi mnx,

I never played with settings.

My question is if it works with one then why not with other as everything is same ?

[nathand]

I'm sorry but the level of your English makes it very difficult to understand you. You should check the cell formatting. Did you try what I suggested - entering the text directly into the cells in Excel, without using LabVIEW, to see if the same thing happens?

Are you sure the cell formatting is the same in both Excel files? Write the same text (same date and time) to both Excel files, and see if the cells in both files display identically.

If there is no difference between Excel files, then please upload your code and a single Excel file that demonstrates that if you write a date in 2013 it displays differently than a date in 2012. If you cannot provide code and an Excel file that shows this behavior, then the problem is likely in your Excel files.

[Ranjeet_Singh]

hi nathand,

                            Cell formatting is same in both the files, I tried entering directly & results are same.

Thats what my question is ?

[nathand]

---

@Ranjeet_Singh wrote:

                            Cell formatting is same in both the files, I tried entering directly & results are same.

Thats what my question is ?

---

Just to be absolutely certain I understand you: when you type a date in 2013 into an Excel sheet, it displays differently than when you type a date in 2012 into the same cell in the same Excel sheet. Is that correct? If you did this with two different files, try it with a single file.

If you see this behavior when you enter the text directly from the keyboard, why are you posting it in a LabVIEW forum? It doesn't seem to have anything to do with LabVIEW.

Why can't you upload your Excel files that demonstrate this behavior?

[Ranjeet_Singh]

I posted this question in forum to know someone else faced this problem ?