We help IT Professionals succeed at work.

date excel help

magento
magento asked
on
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
Comment
Watch Question

BRONZE EXPERT

Commented:
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.
BRONZE EXPERT

Commented:
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.

Author

Commented:
Thanks Brian, let me check it.

Author

Commented:
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?
BRONZE EXPERT
Commented:
magento

Could you post just that column of dates, please? (The whole file would be ideal, but I'm assuming that there's confidential information in it.)

Thanks,
Brian.
BRONZE EXPERT

Commented:
Thanks, magento!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.