I think Jitendra & DHiraj have given the right solution On 5/14/09, Jitendra mhashelkar <jitendra...@gmail.com> 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 < > shrestha.dhi...@gmail.com> wrote: > >> Write as *'11E17 ** >> >> * >> On Thu, May 14, 2009 at 10:39 AM, ritesh paul <riteshkp...@gmail.com>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 <laurence.tha...@navy.mil> 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. 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 change >>>> > 11000000000000000000 (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. >>>> >>>> >> >> >> > > > >
-- Regards, Shreyans Naval Reliance Enenrgy Trading Ltd. +91-9711310051 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
