$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-22 Thread Harmeet Singh
please send the file On Fri, May 22, 2009 at 1:21 AM, god is gr8 i love u wrote: > HI > i want to make chart on data in excel its whole month data > i want to show to difference in timing so which chart will b suitable and > how cn i show the whole month data in chat > also in this i hv 4 columns

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-21 Thread god is gr8 i love u
HI i want to make chart on data in excel its whole month data i want to show to difference in timing so which chart will b suitable and how cn i show the whole month data in chat also in this i hv 4 columns plz help me plz mail me on another id life_is_to_ch...@yahoo.co.in Thanx On Tue, May 19, 20

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-19 Thread 2008ra...@gmail.com
problem is that i take my code's report from my database , i don't write these codes with myself. if someone want to file about that , i can send a excel file. thanks for your helps. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-14 Thread shreyans naval
I think Jitendra & DHiraj have given the right solution On 5/14/09, Jitendra mhashelkar wrote: > > Hi, > > u can giv Single Inverted coma ' before the no. > > e.g: '11E11 > > try this & let me know if it works > > Thanks > > Jitu > > > On Thu, May 14, 2009 at 10:48 AM, dhiraj shrestha < > shres

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-14 Thread Jitendra mhashelkar
Hi, u can giv Single Inverted coma ' before the no. e.g: '11E11 try this & let me know if it works Thanks Jitu On Thu, May 14, 2009 at 10:48 AM, dhiraj shrestha wrote: > Write as *'11E17 ** > > * > On Thu, May 14, 2009 at 10:39 AM, ritesh paul wrote: > >> I think, u need to format the cell

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-14 Thread dhiraj shrestha
Write as *'11E17 ** * On Thu, May 14, 2009 at 10:39 AM, ritesh paul wrote: > I think, u need to format the cell in Number Format. Pls make decimal place > as 0. U should > get the result. > > Paul > > On Wed, May 13, 2009 at 7:26 PM, larry wrote: > >> >> I am talking about the format cells comm

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-13 Thread ritesh paul
I think, u need to format the cell in Number Format. Pls make decimal place as 0. U should get the result. Paul On Wed, May 13, 2009 at 7:26 PM, larry wrote: > > I am talking about the format cells command. If you select a cell or > cells and right click you will see a format cell option. Selec

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-13 Thread larry
I am talking about the format cells command. If you select a cell or cells and right click you will see a format cell option. Select text and your problem may be solved. On May 12, 10:29 am, "2008ra...@gmail.com" <2008ra...@gmail.com> wrote: > i was try the cell text format.but that value is chan

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-12 Thread 2008ra...@gmail.com
i was try the cell text format.but that value is change 1100 (for 11E17) when i do it. i know that problem is give me for scientific notation i was write that VBA for text format but that is not work. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

2009-05-12 Thread larry
Try making the cell text format. The prorgam is converting to scientific notation which is why you are getting the different values. On May 11, 1:14 pm, "2008ra...@gmail.com" <2008ra...@gmail.com> wrote: > Hi > > I have a problem with my goods's code.my goods's code is that bellow > codes and tha