12 January 2013
IN THE FORM-704 OF VAT AUDIT I WANT TO FILL ANNEXTURE-I. IN WHICH DATE IS NEEDED IN 18/06/11 THIS FORMAT ,BUT I HAD EXPORTED DATA FROM SYSTEM AND THE FORMAT IS LIKE 18-06-2011. I TRIED TO CONVERT THAT DATE IN EXCEL USING DATE FORMAT BUT IT IS NOT BEING ACCEPTED IN 704. IS THERE ANY OTHER WAY IN EXCEL BY WHICH I CAN BE ABLE TO CHANGE THE DATE FORMAT?