Many many thanks.
On 7/20/12, Amiyo Biswas <[email protected]> wrote: > You may give it a try. > > Go to format cells dialogue box using ctrl+1. > Press tab key and you will reah the category combo box. Arrow down to the > last category ustom. > Press tab once and type this code > ###.00 > The hash (#) sign is for normal numbers and and the zeroes after the dot > sign is for decimal places. > > What I notice is that if the cell is formatted for percentage beforehand, > the figure displays correctly. Otherwise, Excel tends to multiply it 100 > times. > > > With best Regards, > Amiyo Biswas > Cell: +91-9433464329 > > ----- Original Message ----- > From: "Ekinath Khedekar" <[email protected]> > To: <[email protected]> > Sent: Friday, July 20, 2012 3:14 PM > Subject: Re: [AI] Regarding excel formatting > > > I had faced the same problem. Don't exactly remember how i solved, but > go to number tab as already mentioned and do juggling with decimal or > other formats. > > It will happen. > > > > On 7/20/12, Sameer <[email protected]> wrote: >> >> Dear Friend, >> >> When calculating the percentage before changing the cell format from >> Numbers >> >> to Percentage, have you used the following formula? >> =A1*100/A2, where A1 & A2 contain the data of which the percentage is to >> be >> >> calculated? >> >> If so, kindly change the formula to =A1/A2 & the result will be displayed >> properly. Also, the percentage symbol will also be displayed. >> >> Regards >> Mr. Sameer Latey >> Mumbai, India >> ----- Original Message ----- >> From: "shyam sharma" <[email protected]> >> To: "accessindia" <[email protected]> >> Sent: Friday, July 20, 2012 12:04 PM >> Subject: [AI] Regarding excel formatting >> >> >>> Hello friends, I hope you all are good and happy. A very good morning >>> to all of you. >>> I want to share an excel problem with you and hope for any solution >>> from your side. >>> When I change the formatting from number to Percentage, the data >>> sounds little strange. >>> Like in any cell I have written >>> 54.12 >>> then after changing it into percentage formatting it will sound as >>> 5412% >>> I want it to be 54.12% with the percentage formatting. >>> How can we do it? >>> with thanks >>> Shyam >>> >>> >>> 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 >> >> > > > -- > “The waves breaking on the surface draw all the attention, > but it is the current beneath the water that determines your direction.” > > > 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
