Excel not formatting cell contents as numbers, won't sum cells -decimal separator - comma and point

Excel not formatting cell contents as numbers -Decimal separator - comma and point
Use comma as decimal point, or use full stop and decimal point

[@Asslapper69]

the only guy i could find that managed to explain this thank you from the bottom of my heart

[@tommysmith5580]

man, ive been searching for this answer for 2 hours, your a legend

[@michalorenc6637]

not only you unfortunately

[@iborass]

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?

[@tommysmith5580]

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

[@Diogo_1143]

Dude, i searched the entire web and only your solution worked! Thanks!

[@nekopaw-]

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!! 💕😇

[@user-jt6ln8cf9k]

Yes, I spent 45 mins trying to fix this and you saved me another 45 and a headache, thanks mate!

[@luisbriceno2549]

The only video that explains it in the whole web

[@michalorenc6637]

trueee

[@user-jj8tj8uj6q]

Spent the entire day searching the solution.Thank you so much!!! Finally came across your video.🎉

[@weiweitju7341]

I watch some youtube video to have my problem solved... but only yours can answer my problem. thank you so much

[@ecologicaltime]

thank you

[@johannothnagel137]

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 🙏🙏🙏

[@gusgray06]

Yes, ditto.

[@parisobel601]

Thank you so much. I searched and searched, even had a little cry over it. You are the biggest legend.

[@mehulmistri4350]

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

[@jrscheepers845]

A flippen Legend!! Thank you! I have a test tomorrow on excel stuff and I was flipping out thinking my laptop is mad.

[@OfficeSmarrt]

genius, you;ve saved me 2 hours of work

[@orlamartin7564]

Thank you! no way in a million years would I have figured that out :)

[@itumelengmmatli5913]

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

[@declansgamereview6523]

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

[@abhishekparikh8960]

Thanks a lot !! That's exactly what I needed (Of course after a lot of hustling around on RUclips).

[@boinkosibongi748]

Saaame😭

[@garethmoyo9791]

You saved me from having a stroke😭

[@PeluangBisnisRumahanaja]

I don't know why using the file-option method doesn't work, after searching others channels only here it works. TYSM

[@user-eg1bt5dh4k]

Thank you so much...finally i found the right video 🎉

[@Someone11i]

Bro you saved my life thank you!!! I have been stuck on my task since yesterday I just finished it

[@nhlanhlamvelase473]

Thank you I spent the past 3 days trying to figure this out

[@corneliawolfaard7353]

You are a genius. Thank you. Love South Africa brains

[@negruandrei6626]

Huge thanks man! You saved me hours of work

[@alwyntheIII]

What a Legend! It worked for me. Thanks dude, saved me a lot of time.

[@Markredgandalf]

Thanks for that helpful info. 😊

[@joelnamabwaza3896]

Finally you have saved me eshi

[@samirnagarji]

Thank you for saving my life 😂
Very much helpful. 🎉

[@Carrymejane]

DUDEE THANK YOU SO MUCH, I LOVE U SO MUCH MR

[@lvolanteml]

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

[@penipoloniati]

awesome explanation

[@soleidacarranza6270]

You are a genius!

[@nshimiyimanamuhamadi4126]

Much Helpful

[@AlexandruRobert]

FINALLY the answer to my problem...

[@swampflower2]

u deserve a bag of gold, bro ! ((: ♥

[@kindungo2]

Thank you very much

[@averageenjoyer8536]

Thanks mate youre a legend

[@leratolekgowe4331]

Thanks u saved the day

[@naktode]

thanks a lot 🙏🙏

[@sajibsarker3169]

Thx bro
helps a lot

[@shihasshanavas1082]

Tons of thanks 🎉

[@lemon3165]

I was going nuts😂😂thx

[@amandadias4599]

Thank you!!!

[@satyendrayt]

Legend brother selute to you 😊

[@abhiachar7222]

Tq u tqs a lot take my indian namaste🙏

[@airvent-gg8yl]

thanx for the info bruv

[@MrJirkaCZ]

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.

[@MrJirkaCZ]

Edit: Maybe just the First things is neccessarry. You might select entire column.

[@Anord25]

thank you sir

[@margaritalopezcrook8776]

THAAAANK YOUUUUU ❤🎉

[@sabirullahafridi8660]

Thank you :)

[@salmanahmed-wm1dz]

Thanks man

[@calito44]

Man thks !!!

[@jameskalenga7546]

Thanks a lot

[@mayurbari4343]

Thanks

[@TFCentertainment]

How convert 1.00 as tees to text ,it shows only 1 pls help and reply

[@tonyakriba6836]

LIFE SAVER

[@kartiksingh191]

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?

[@yahiamagdy9561]

thanks alot

[@VRUNO]

Genius!

[@ferysusanto1484]

why it didn't work at my excel???

[@tshepomononyane2500]

THANKS A LOT OMG

[@snsinha5803]

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.

[@dinopa4628]

Your method is still not worked for me

[@vanscoyoc]

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!

[@hshivaprasad7631]

Sir more the 2 commas unable to sum

[@phoenix447]

Holy shit you're a fucking godsend

[@JM-xk6oz]

Thank you.

[@jimsagubigula7337]

Doesn't work

[@meerhossain2746]

Thank you very much

[@justicerhulani6681]

Thanks man

[@uranbilegz]

Thank you so much