Date Formatting

[aroraditya]

Dear All,

Good Day!

I am very new to this forum, and this is my first post here.

My problem :- we are using a excel 2007 file in which we have to fill date in it in dd/mm/yyyy format. we format the whole column in this format. when we enter the date it save it correct format but after some time it automatically change into ddmmyyyy format.

Please help it really very annoying. To format column again and again.


Thanks in advance



Regards / Aditya

 

[VaraK]

Hi Aditya,

How do you fill the date in the cells? manual input or a formula?

Do you know if the file has an event procedure that changes the format of the column?

I use 2007 as well and I haven't come across this issue till date.

 

[aroraditya]

we use manual input.