magento
asked on
date excel help
Hi,
I have a column with dates, which i need to change the format.
i/p:
01/01/2011
03/01/2011
01/05/2011
o/p:
01-JAN-2011
01-MAR-2011
05-JAN-2011
I tried custom format with dd-MMM-yyyy , its not working any advice?
Thanks
I have a column with dates, which i need to change the format.
i/p:
01/01/2011
03/01/2011
01/05/2011
o/p:
01-JAN-2011
01-MAR-2011
05-JAN-2011
I tried custom format with dd-MMM-yyyy , its not working any advice?
Thanks
magento,
Assuming they don't come back as a number, you can quickly use "Text to Columns" to convert them to actual dates (on Step 3 select the appropriate date format). Let me know if you need any help with that.
Regards,
Brian.
Assuming they don't come back as a number, you can quickly use "Text to Columns" to convert them to actual dates (on Step 3 select the appropriate date format). Let me know if you need any help with that.
Regards,
Brian.
ASKER
Thanks Brian, let me check it.
ASKER
It works , but the problem is ..when i double click the cell and click outside it changes, otherwise it remains same.
There are about 1000 rows..how to proceed?
There are about 1000 rows..how to proceed?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, magento!
It's possible that the dates are actually text and so not recognised by Excel as dates. Try changing the cells' format to "Number". If the values are dates, you should values like such as 40849.7861111111 (with or without the decimals).
Regards,
Brian.