solcosmico
New Member
- Joined
- Dec 10, 2005
- Messages
- 4
Hello,
I am beginner and having issue with the date hour format.
I have an excel file that I convert into excel format from a csv file. All the columns are "date HH:mm 0-24" format although some lines (not all of them, strangely) remain with the "date HH:mm AM/PM" format visually even if the good format is selected ("date HH:mm 0-24").
We found out that this problem occurs only when the Windows date hour format settings are set to UK, but not when set to USA.
How can i get the format setins to work properly ? anybody ever faced that bug ?
Thanks for your help
???
I am beginner and having issue with the date hour format.
I have an excel file that I convert into excel format from a csv file. All the columns are "date HH:mm 0-24" format although some lines (not all of them, strangely) remain with the "date HH:mm AM/PM" format visually even if the good format is selected ("date HH:mm 0-24").
We found out that this problem occurs only when the Windows date hour format settings are set to UK, but not when set to USA.
How can i get the format setins to work properly ? anybody ever faced that bug ?
Thanks for your help
???