$$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

Dear Gurus, I have a file which has the values like 6 - 11 7 - 20 2 - 27 which is automatically changing to date format but it should display the same 6 - 11 7 - 20 2 - 27 Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

Dear Sundar, Please convert cell as Text Select required cell and press ctrl+1 and change format of cell as text. On Thu, Nov 1, 2012 at 11:52 AM, Sundarvelan N wrote: > Dear Gurus, > > I have a file which has the values like 6 - 11 > > 7 - 20 > > 2 - 27 > > which is automatically changing to