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. >>> >>> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
