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
