After hours of searching and finding the same useless answers. your first solution fixed my problem. Here is a little gift to say thanks!
@ChesterTugwell
Жыл бұрын
Many thanks for your gift!
@vong687
Жыл бұрын
@@ChesterTugwell My pleasure. I know how hard the economy has been on creators and the hard work that goes into making good content. I wish more people would start tipping creators that produce actual useful and valuable content that helps them out.
@nikhilpunjabi7073
10 ай бұрын
was stuck for a day...saw this video and resolved in seconds... thankyou! Very useful.
@TalsaaFinance
10 күн бұрын
Thank you so much. As many others, I ran into this issue and spent a lot of time trying to sort it out. You provided an easy to access and get right to the point answer!! Excellent!
@harun5466
9 күн бұрын
My problem was solved within seconds of watching your video... A BIG THANK YOU✌🙏
@ChesterTugwell
6 күн бұрын
Welcome 👍
@tony_austin
Жыл бұрын
I found another case that drove me mad until I at last figured it out. I copied a number from a from a web page, any browser (and MS Word is the same) by double clicking and then pasted it into a MS Excel cell - it showed as left-aligned even with cell type = Number and the only method I found that worked was to manually remove the trailing space! There are dozens of solutions to the problem you describe but none of them worked for me when I copied a text number from browser and pasted into Excel.
@jerrydilger
7 ай бұрын
Thank you so much! Option 2 PASTE SPECIAL did the trick for my table!
@angelabarnes6410
Жыл бұрын
Exactly what I was looking for. Thanks!
@2000konnie
2 жыл бұрын
This is great! I used to create another column and multiply the cell by 1. But these are much better. Thank you 😊
@DeborahRich-o1i
Жыл бұрын
Thank you Chester! It too quite a while to try to find the right information. I found your video this morning and it solved the problem.
@PJsAllDayFR
8 ай бұрын
Thank you for the rescue. Very straightforward presentation!
@Ivana658
4 ай бұрын
How many times I have to like this video?! Thank you, thank you, thank you!
@elizabethsoliz7092
11 ай бұрын
The last option helped me. Thank you! 😊
@gavinvoon3708
2 ай бұрын
Omg i have been stuck on this for a whole bloody day! Thank you so much for the help
@IvanCortinas_ES
2 жыл бұрын
Good video Chester! Thank you for explaining these three methods.
@BillPalmer
4 ай бұрын
Perfect! exactly what I needed to solve this issue. Great video: right to the point,
@JolYik
8 ай бұрын
was stuck for a year, amazing video
@williampriesterjr.5077
3 ай бұрын
Thank you for your help with the text-to-columns trick there.
@heenriyeow8822
Жыл бұрын
you save my life. thank you so much!
@lorigoedken8149
Жыл бұрын
Good simple explanation. My problem is that none of those options are showing on my screen. I’m on the latest version of Mac
@judy5liu
Жыл бұрын
Thank you. Very helpful video.
@michaeldecaro3693
Жыл бұрын
Extremely helpful! Thank you so much!
@ChesterTugwell
Жыл бұрын
Glad it was helpful!
@pramodmulam4785
Жыл бұрын
Thank You!!! Very Helpful...
@jorowley6523
11 ай бұрын
Hi Chester, love your following your videos, I am looking into setting up an A to Z document, do you have any info on it?
@mustafayusuf4112
7 ай бұрын
Thank you Chester Tugwell.
@socialinnovation1863
5 ай бұрын
excellent! option #1 worked for us!
@DanielleTropiano
Жыл бұрын
None of these options are working for me :/ Once I updated my Excel I lost all normal functions such as this
@ndivmakatu
6 ай бұрын
i need assistance with my data that is not counting at the bottom right. when i filter with blanks it shows so much information but i cant count it. how do i fix that. your assistance will be helpful
@jasontuomisto1996
Жыл бұрын
Thank you!
@AbdullaAbdullayev
4 ай бұрын
Worked for me. Thanks!
@aayushikumar7937
10 ай бұрын
Im not sure why none of them is working for me ? maybe its coz i have rs. sign in starting of the no. can u help with that
@hazemali382
2 жыл бұрын
Many Thanks ♥
@nisarabbas6591
Жыл бұрын
So Nice sir
@nitinyashverma
3 ай бұрын
Thank you so much!!!
@JoMarieHartup
7 ай бұрын
Thank you so much
@jessiesaytas6590
7 ай бұрын
What if the converted text to number didn't appear?
@Vinchellby
Жыл бұрын
text to columns is not showing in my excel
@sinrithy6472
8 ай бұрын
Thank you it work
@ernestakruger6231
6 күн бұрын
What if I still get 0,00?
@ashimaverma9752
3 ай бұрын
TYSM :)
@leopoelstra
2 ай бұрын
any idea why is this problem happening? :/ and yes, thanks a lot!
@Ivana658
11 ай бұрын
Thanks!!
@SplitPhotography
2 ай бұрын
None are as text here, but still will not sum it up. Just shows - or 0.00 or other depending on formating. Going nuts....
@palashpriyanshudutta4853
Жыл бұрын
Damn your voice. Morgan freeman has a rival .
@SPENCERPHILLIPS-fg5gi
9 ай бұрын
Still not fixed mine unfortunately but thanks anyway.
Пікірлер: 50