Link to home
Start Free TrialLog in
Avatar of magento
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
Avatar of redmondb
redmondb
Flag of Afghanistan image

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.
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.
Avatar of magento
magento

ASKER

Thanks Brian, let me check it.
Avatar of magento

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?
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, magento!