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