Dates shown in one format and when clicked, shown in another format

[gursimarsinghmiglani]

When i view my excel file, the dates are in dd/mm/yyyy format. When i click on the date, it changes to mm/dd/yyyy format. When i click on format cell, the format is dd/mm/yyyy. This is causing me trouble as i have built an excel processor app that is not functioning correctly due to this. Why is this happening? What can I do?

 

[awoohaw]

are the values actually changing? Excel displays your system default date format for the date in the formula bar, but the values are not changed. If this is not the explanation, then please show some examples of how the values are changing?

Book1
	A	B	C
1
2		value:	display
3	Short (my stystem)	45413	2024-05-01
4	Long	45413	Wednesday, May 1, 2024
5	mm-dd-yyyy	45413	05-01-2024
6	dd-mm-yyyy	45413	01-05-2024
Sheet2