Oh!Calcutta
New Member
- Joined
- Jun 15, 2011
- Messages
- 26
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
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
