Hi, To read formula letter by letter, press F2 function key on the cell containing formula. When you have finish reading, press ESCAPE key to come out from edit mode. Note: You can also make the necessary changes after pressing the F2 function key.
On 3/22/12, giri prasad <[email protected]> wrote: > Thank you very much sir. I have two more things to get clarified. > > 1. How do we read a cell containing formula letter by letter? > > 2. If I type some number in figures that is 123 in A1, how do I get > 123 in words in B1? > > > > On 22/03/2012, Zujar Shabbir Kanchwala <[email protected]> wrote: >> Thanks Zoher for the correction. I realized that while watching TV after >> sending the email, so turned on the Internet to send out the correction >> and >> found your email with the same content. >> >> Best Regards, >> Zujar >> >> An optimist laughs to forget while a pessimist forgets to laugh... >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of zoher >> Sent: Thursday, March 22, 2012 8:51 PM >> To: [email protected] >> Subject: Re: [AI] Rounding up percentage. >> >> dear zujar in your formula the importent part is missing. that is the how >> many desimal point you want to round up to.in the above query the person >> wants to round the figure to 0 desimal point so the formula will be, >> =round((25*15%),0) >> =round((25*13%),0) >> ----- Original Message ----- >> From: "Zujar Shabbir Kanchwala" <[email protected]> >> To: <[email protected]> >> Sent: Thursday, March 22, 2012 8:32 PM >> Subject: Re: [AI] Rounding up percentage. >> >> >>> Use theROUND() function. Your examples rewritten below: >>> >>> 1. =ROUND(25*15%) >>> 2. =ROUND(25*13%) >>> >>> The above formulae return 4 and 3 respectively as desired. >>> >>> Best Regards, >>> Zujar >>> >>> An optimist laughs to forget while a pessimist forgets to laugh... >>> >>> -----Original Message----- >>> From: [email protected] >>> [mailto:[email protected]] On Behalf Of giri prasad >>> Sent: Thursday, March 22, 2012 7:24 PM >>> To: [email protected] >>> Subject: [AI] Rounding up percentage. >>> >>> Dear list members, I have a queery related to excel regarding rounding >>> up percentage. >>> I am not sure whether I will be able to explain it well. I therefore >>> will explain it giving an example. For instance if we give the formula >>> 1. =25*15% we get 3.75. >>> 2. =25*13% we get 3.25. >>> >>> In the first example, after the decimal point, if the value is greater >>> than or equal to 5, I want it to be rounded up to the next digit that >>> is 4. >>> >>> If the value is less than 5 after the decimal point, I want it to be >>> rounded to the previous digit that is 3 in the second example. >>> How do I do this? I will be grateful if some one can help me out. >>> >>> >>> -- >>> WITH REGARDS >>> >>> GIRIPRASAD >>> >>> MOBILE 924710000 / 9441133367 >>> >>> SKYPE giriprasad.maddina >>> >>> "Our greatest glory consists not in never falling, >>> but in rising every time we fall." >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> > > > -- > WITH REGARDS > > GIRIPRASAD > > MOBILE 924710000 / 9441133367 > > SKYPE giriprasad.maddina > > "Our greatest glory consists not in never falling, > but in rising every time we fall." > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- "Life is like a piano. White keys are happy moments & Black keys are sad moments. But remember both keys are played together to give sweet music." "Focus on your abilities, not your disability." Warm Regards, Have a nice day Hozefa... Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
