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
