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 > .·:* > *:·. > *«*:·. > .·:* > *:·. > > > > <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline....@middle?> > ------------------------------ > Add more friends to your messenger and enjoy! Invite them now. > > > > <http://in.rd.yahoo.com/tagline_messenger_6/*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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
