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
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
Last edited by farrukh; 04-03-2011 at 11:34 AM.
What file extention are you xls files ? What sheets ? What cells ?
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
Please Login or Register to view this content.
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
Please Login or Register to view this content.
Dear Nimrod
Thank you for your kind and nice support thanks alot
Last edited by farrukh; 03-31-2011 at 01:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks