Excel not formatting cell contents as numbers, won't sum cells -decimal separator - comma and point
HTML-код
- Опубликовано: 4 сен 2024
- Excel not formatting cell contents as numbers -Decimal separator - comma and point
Use comma as decimal point, or use full stop and decimal point
the only guy i could find that managed to explain this thank you from the bottom of my heart
man, ive been searching for this answer for 2 hours, your a legend
not only you unfortunately
Agree, true HERO! thanks man. Now i have problem as soon as I press refresh i get numbers as it was on the start. Excel see the numbers as text again. any idea?
if the number doesnt need to be changable from other cell inputs i would maybe just copy and paste as value. (cntr + c) ) then (cntrl+alt+v) pick as values @@iborass
Dude, i searched the entire web and only your solution worked! Thanks!
This was driving me crazy as I had to sum all the values manually and couldn't find a way to fix it. I am using IOS system and your solution worked perfectly for it too! Thank you sooo much!! 💕😇
Yes, I spent 45 mins trying to fix this and you saved me another 45 and a headache, thanks mate!
The only video that explains it in the whole web
trueee
Spent the entire day searching the solution.Thank you so much!!! Finally came across your video.🎉
I watch some youtube video to have my problem solved... but only yours can answer my problem. thank you so much
thank you
Looking for hours on RUclips through so many videos and eventually this guy explained it in such an easy way to fix the problem - Well Done and Thankyou 🙏🙏🙏
Yes, ditto.
Thank you so much. I searched and searched, even had a little cry over it. You are the biggest legend.
Saved Me ❤ From my heart attack. Bravo !! 💫 Thank you for help Solving to try from last 3 hours.....Your video really helpful
There is only one video entire RUclips, and Internet 🙌🏻🙌🏻
My pc was not showing dot and not calculating dot value Now, Both solved
A flippen Legend!! Thank you! I have a test tomorrow on excel stuff and I was flipping out thinking my laptop is mad.
genius, you;ve saved me 2 hours of work
Thank you! no way in a million years would I have figured that out :)
Wow Thanks Man. I've Watched Over 5 Videos Here On You Tube & Non Helped. You Solved My Issue of Adding a Long Column of Numbers With 0 Total. Thanks a Lot Man. This Worked
From South Africa
damn - thank you so much regarding the comma thing vs dot. Been through so many videos online and they all talking about other stuff that did not fix my issue. Dankie baie
Thanks a lot !! That's exactly what I needed (Of course after a lot of hustling around on RUclips).
Saaame😭
You saved me from having a stroke😭
I don't know why using the file-option method doesn't work, after searching others channels only here it works. TYSM
Thank you so much...finally i found the right video 🎉
Bro you saved my life thank you!!! I have been stuck on my task since yesterday I just finished it
Thank you I spent the past 3 days trying to figure this out
You are a genius. Thank you. Love South Africa brains
Huge thanks man! You saved me hours of work
What a Legend! It worked for me. Thanks dude, saved me a lot of time.
Thanks for that helpful info. 😊
Finally you have saved me eshi
Thank you for saving my life 😂
Very much helpful. 🎉
DUDEE THANK YOU SO MUCH, I LOVE U SO MUCH MR
Do you have to do this each time? Or is there a setting in options that can just make it a default? I changed the setting you mentioned in options but still have to configure to columns
awesome explanation
You are a genius!
Much Helpful
FINALLY the answer to my problem...
u deserve a bag of gold, bro ! ((: ♥
Thank you very much
Thanks mate youre a legend
Thanks u saved the day
thanks a lot 🙏🙏
Thx bro
helps a lot
Tons of thanks 🎉
I was going nuts😂😂thx
Thank you!!!
Legend brother selute to you 😊
Tq u tqs a lot take my indian namaste🙏
thanx for the info bruv
Note: First you have to have SAVED file - so it has to exists and not be just a draft. Second you have to select exact fields, not entire column because my text in field 1 broke the rule. At least for me it didnt work and work after I did those things.
Edit: Maybe just the First things is neccessarry. You might select entire column.
thank you sir
THAAAANK YOUUUUU ❤🎉
Thank you :)
Thanks man
Man thks !!!
Thanks a lot
Thanks
How convert 1.00 as tees to text ,it shows only 1 pls help and reply
LIFE SAVER
hello sir,i want decimal digits in seprate cell. how can i do this
suppose there is a number 243.66
now i want 243 in different cell and 66 in different
how can i do this?
thanks alot
Genius!
why it didn't work at my excel???
THANKS A LOT OMG
pl. sum this value.
1,00,000.00
1,50,000.00
4,00,000.00 i m trying many way but not getting. Please guide.
Your method is still not worked for me
I see this as just another example of terrible MS programming. If excel thinks that a period is a comma then EXCEL HAS TO DISPLAY TO THE USER WHAT IT THINK IT IS..NOT SOMETHING ELSE LIKE A PERIOD! WTF MICROSOFT GET YOUR CRAP TOGETHER FOR ONCE!
Sir more the 2 commas unable to sum
Holy shit you're a fucking godsend
Thank you.
Doesn't work
Thank you very much
Thanks man
Thank you so much