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