convert date format to text in all excel files in a folder

**farrukh** · 03-31-2011, 12:32 AM

Hi All,

i need a code that open all excel files change the specific cell date format to text format.

I have 100's of files it is difficult to open each file and convert date to text format.

Thanks
Farrukh

**nimrod** · 03-31-2011, 12:38 AM

What file extention are you xls files ? What sheets ? What cells ?

**farrukh** · 03-31-2011, 12:43 AM

Thanks for your reply
i have a file extention is .xls, Sheet1 only have the data and cell is I13 having the date in all excel files.

Thanks and Regards
Farrukh

**nimrod** · 03-31-2011, 01:07 AM

Please Login or Register  to view this content.

**farrukh** · 03-31-2011, 01:31 AM

Thanks a lot the code perfectly works only the problem i have while converting the date to text suppose the date is 01-jan-2009 (dd-mmm-yyyy) it convert it like that 39814, i need to convert the date as it is like 01-jan-2009.

Thanks
Farrukh

**nimrod** · 03-31-2011, 11:12 AM

Please Login or Register  to view this content.

**farrukh** · 03-31-2011, 01:12 PM

Dear Nimrod

Thank you for your kind and nice support thanks alot

convert date format to text in all excel files in a folder

LinkBack

Thread Tools

Rate This Thread

Display

convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Re: convert date format to text in all excel files in a folder

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions