So when the cell is pre-formatted, typing .03 gets you 3%. I see that if I type 0.03 (zero before the decimal point) I can force it to give me 0.03%. Or I suppose you could also type .0003, but that's beginning to feel awkward.
Anyway, thanks so much for all these great videos. I love how into short-cuts you are, and the fact that you narrate your key-presses is really helping me to learn them.
Thank you for explaining this, I've been Googling for ages and found nothing. Now I can display my formatted cells as a percent just by dividing the other cells by 100! :-)
Is there any solution if I want to insert a number and receive this number formatted with the percentage simbol "%" after it, avoiding that excel writes me the number mulptiplying it for 100 ?
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.
excel is weird. the second cell where you preformatted % and typed in .03 should in actually be: .0003% (because we * by .01)not 3% as excel makes it out to be
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!
So when the cell is pre-formatted, typing .03 gets you 3%. I see that if I type 0.03 (zero before the decimal point) I can force it to give me 0.03%. Or I suppose you could also type .0003, but that's beginning to feel awkward.
Anyway, thanks so much for all these great videos. I love how into short-cuts you are, and the fact that you narrate your key-presses is really helping me to learn them.
gemmation 3 months ago
you're Great!
minesungte 3 months ago
@minesungte , I am glad that you like the video!
ExcelIsFun 3 months ago
Thank you for explaining this, I've been Googling for ages and found nothing. Now I can display my formatted cells as a percent just by dividing the other cells by 100! :-)
George19881988 9 months ago
You are welcome! I am glad that the video helped!
ExcelIsFun 9 months ago
Is there any solution if I want to insert a number and receive this number formatted with the percentage simbol "%" after it, avoiding that excel writes me the number mulptiplying it for 100 ?
Regards
dabruna 1 year ago
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.
ExcelIsFun 1 year ago
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?
549606 2 years ago
Maybe global settings:
Control Pannel, Regional and Language Settings.
ExcelIsFun 2 years ago
excel is weird. the second cell where you preformatted % and typed in .03 should in actually be: .0003% (because we * by .01)not 3% as excel makes it out to be
slaves2sin 2 years ago
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
ExcelIsFun 2 years ago
Thanks a lot
Underxman 2 years ago
Dear Underxman,
You are welcome!
--excelisfun
ExcelIsFun 2 years ago
excellent job
chippendails 2 years ago
Dear chippendails,
Thanks! Did you mean "EXCELlent!!!"?
--excelisfun
ExcelIsFun 2 years ago
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
quirky524 3 years ago
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
ExcelIsFun 3 years ago