Thanks Aindril !!!!!!!!!!! its working --- On Sat, 4/4/09, Aindril De <aind...@gmail.com> wrote:
From: Aindril De <aind...@gmail.com> Subject: $$Excel-Macros$$ Re: urgent help req. To: excel-macros@googlegroups.com Date: Saturday, 4 April, 2009, 9:33 AM Hi Sashank if u enter the value in cell A1 and want to see the decimal value in A2 then just type =A1/100 in the cell A2. Regards, Andy On Sat, Apr 4, 2009 at 1:46 AM, shashank bhosle <catchshashankbho...@yahoo.co.in> wrote: HI All, I am having a Excel file where i need to imput the Numerical Value. e.g 12356 but i want the same cell or adjacent cell should reflect as 123.56 i.e decimal should move two places Advance thanks Regards, U r s... Shashank 9975620752 Never Born Never Die Just visited the Earth for a while .·:* *:·. *«*:·. .·:* *:·. Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---