how to set first column as date (dd/mm/yyyy) in the specific format in excel

[jeyanthi]

hi need help wat i did need help is tht i need wen ever i send view a excel data  the first column set to date  but some times wen i view in different type of pc the date format change to mm/dd/yyyy. is  thr any way i can set the format?

[RavensFan]

Does this question relate to LabVIEW?  It sounds like your issue is strictly with the way Excel is displaying a date.  If your column in excel is not set to a specific data format, it is probably relying on the regional settings as they are set in control panel for which way dates are displayed.  This setting could vary between PC's and even between different users on the same PC.

[RnDMonkey]

If you just need to reformat a correct date to show up as dd/mm/yyyy, just use the "Format Cells" command and set a custom format string to exactly that. If, on the other hand, you are finding that Excel just doesn't get that the first value is a DAY, not a month, such as trying to graph a temperature data logger that records data in dd/mm/yyyy:

Reformat the strings as dd/mm/yyyy, using the first method. This will make them LOOK correct, even though the actual date VALUES are still day-month inverted. Now save the table as a .CSV file. This will save the dates as plain text in the correct order, which you can then re-import and have Excel now read the correct date value. 🙂