Date Format

[Oh!Calcutta]

Dear All,

I'm using Excel 2007 for sales data about 2000 rows. The operator is using Invoice date sometimes as MM/DD/YY and sometimes as DD/MM/YY.

I need to use Invoice date in DD/MM/YYYY format for Govt Report.

Pl help me how to convert operator's date column in my desired DD/MM/YYYY format

 

[Yahya]

Hi
just select His date, and Right Click --> format cells --> Custom then use DD/MM/YYYY