Yes, if you want 5.00% in the cell, just type 5.00%. This will put the number 0.05 in the cell and format it with the Percentage Number format 5.00%. In the cell is 0.05 and ontop of the cell for us to "see" is 5.00%. With Excel you never have to multiply by 100.
Thank you for this excellent video series! I'm an MBA student at California State University, Long Beach and your videos really helped me learn Excel for my Finance classes! Thank you once again!
Hi, I have been following ur videos for a few days and it has been great help to learn things systematically. Thank you very much. The direct link however did not work. Thanks again, Sujit
Great thanks. You went straight to the heart of the problem e.g. I want 3% and it shows 300% Was driving me mad but now I know - thanks to your expert help. Much appreciated.
Dear slaves2sin, It may be weird, but remember, when you preformatted then type .03, the % sign does not pop up; but if you type 3, the % symbol pops up. So those two different signals are your clues to how Excel will handle it. I will tell you, slaves2sin, if you keep watching the videos and keep studying as much as you are, you are going to be one great Excel Master! --excelisfun
Good video. I can't use .03 to make 3% theres something wrong with my configuration. It worked only with ,03 . How can change to work with point and with comma?
Yes, if you want 5.00% in the cell, just type 5.00%. This will put the number 0.05 in the cell and format it with the Percentage Number format 5.00%. In the cell is 0.05 and ontop of the cell for us to "see" is 5.00%. With Excel you never have to multiply by 100.
You are welcome! I am glad that the video helped!
Thank you for this excellent video series! I'm an MBA student at California State University, Long Beach and your videos really helped me learn Excel for my Finance classes! Thank you once again!
Hi,
I have been following ur videos for a few days and it has been great help to learn things systematically. Thank you very much.
The direct link however did not work.
Thanks again,
Sujit
Dear Underxman,
You are welcome!
--excelisfun
I am glad that you like it!
Great thanks. You went straight to the heart of the problem e.g. I want 3% and it shows 300% Was driving me mad but now I know - thanks to your expert help. Much appreciated.
Dear slaves2sin,
It may be weird, but remember, when you preformatted then type .03, the % sign does not pop up; but if you type 3, the % symbol pops up. So those two different signals are your clues to how Excel will handle it.
I will tell you, slaves2sin, if you keep watching the videos and keep studying as much as you are, you are going to be one great Excel Master!
--excelisfun
@minesungte , I am glad that you like the video!
Maybe global settings:
Control Pannel, Regional and Language Settings.
You are welcome!
Dear quirky524,
I agree with you, learning systematically is a good way to learn!
Which link did not work? My college web site link?
--excelisfun
Dear chippendails,
Thanks! Did you mean "EXCELlent!!!"?
--excelisfun
Great video as always
Good video. I can't use .03 to make 3% theres something wrong with my configuration. It worked only with ,03 .
How can change to work with point and with comma?
11 years ago.....
It still is the same all these years later : )
Thank you for your support, Rupali, with your comment, thumbs up and Sub : )
GREAT TUTOR, THANKS ALOT
you're Great!
Thank you!
You are welcome, Carol!!!
I asked you to do one thing, all yu had to do was show me how to change the format to precent style , everything else was irrelevant
Excel is a junk program when talking about percentage and numbers.
I am trying to write 4.005 for a currency and is IMPOSSIBLE.
Total filled TRASH CAN