سلام؛ حامد قاسمی هستم و امروز به اتفاق هم میخواهیم دو مشکل رایج در اکسل را برطرف کنیم که ممکن است در حین انجام کار با اکسل سبب بروز مشکل شوند. هدف ما در این پست رفع مشکل کاما در اکسل و رفع مشکل نقطه ویرگول در اکسل و همچنین رفع مشکل علامت منفی در سمت راست می باشد که از جمله مشکلاتی هستند که کاربران اکسل با آن مواجه می شوند .
در اینجا جدولی از فهرست کشورهای دنیا قرار دارد که اطلاعات جمعیت و مساحت هرکدام از کشورها در آن آورده شده است.
بهراحتی نسبت جمعیت به مساحت با تقسیمی ساده بهدست میآید اما اعدادی که نمایش میدهد، اعشاری هستند و اعشار را با ممیز جدا کرده است. از طرفی، میدانیم در نرمافزار اکسل بهصورت پیش فرض، کاراکتری که اعشار را جدا میکند نقطه (Point) است.
چطور میتوانیم این کاراکتر را تغییر دهیم؟ و چرا اصلاً مشکلساز است؟ به این دلیل که اگر فرمولهای دیگری نیز بنویسیم و مثلاً را1 تقسیم بر 5 کنیم، پاسخ را بهصورت 1 ممیز 5 نشان میدهد و نتیجه که 0.2 است را نمایش نمیدهد.
دومین مشکل چیست؟ فرض کنید میخواهیم تعداد کشورهایی که در اروپای شرقی هستند را در اینجا بشماریم.
برای این کار میتوانیم از فرمول countif استفاده کنیم. البته این فرمول بهعنوان مثال است اما برای نوشتن هر فرمولی دیگری، همین مشکل به وجود خواهد آمد. فرمول countif دو ورودی (Argument) دارد، اولی Range است.
Range را وارد میکنیم. حالا باید از جدا کننده (List separator) استفاده کنیم تا دو Argument از هم جدا شوند. میبینیم که جدا کننده یک نقطه ویرگول (Semicolon) فارسی است و برای تایپ آن باید صفحه کلید را فارسی کرده و shift + Y را بزنم.
ورودی دوم تابع فرمان شرطی (criteria) است که در سلول G2 قرار دارد. به محض اینکه روی آن کلیک می کنیم، از سلول خارج شده و فرمول ناقص میماند.
اما این دو مشکل را میتوان بهسادگی برطرف کرد.
این مشکل زمانی پیش میآید که ما فرمت اعداد، Time، Date و بطور کلی تنظیمات منطقه را در ویندوز روی Persian قرار میدهیم.
برای رفع مشکل نخست از control panel ویندوز، وارد قسمت Region میشویم.
این مشکل زمانی پیش میآید که ما فرمت اعداد، Time، Date و بطور کلی تنظیمات منطقه را در ویندوز روی Persian قرار میدهیم.
برای رفع مشکل نخست از control panel ویندوز، وارد قسمت Region میشویم.
با زدن دکمه Additional setting وارد تنظیمات فرمت اعداد می شویم. در اینجا میبینید که Decimal symbol روی حالت “/” ست شده است یعنی برای جداکردن اعداد صحیح و اعشاری، آنها را با اسلش (Slash) از هم جدا میکند. کافی است بهجای آن یک نقطه بگذاریم.
مشکل دوم List separator است که مقدار آن روی نقطه ویرگول (Semicolon) فارسی ست شده است. برای حل این مشکل میتوانیم بهراحتی Semicolon انگلیسی را جایگزین آن کنیم. اینجا میتوانیم کاما نیز بگذاریم. ولی پیشنهاد میشود زمانی که فرمت ویندوز Persian است، آن را روی Semicolon بگذارید.
در اینجا میتوانیم مشکل سوم را نیز برطرف کنیم. زمانی که زبان را روی فارسی ست می کنیم ویندوز علامت منفی را سمت راست اعداد نشان می دهد! که خیلی مطلوب نیست. میتوانیم آن را روی حالتی که منفی سمت چپ عدد است، ست کنیم. و OK را می زنیم.
حالا بدون اینکه نیازی به Restart کردن اکسل باشد، مشکل برطرف میشود.
به این ترتیب اعداد صحیح و اعشار با نقطه جدا شده و فرمولها را میتوان با نقطه ویرگول انگلیسی نوشت.
موفق باشید.
من بلوک متن هستم. برای تغییر این متن روی دکمه ویرایش کلیک کنید.
من بلوک متن هستم. برای تغییر این متن روی دکمه ویرایش کلیک کنید.
من بلوک متن هستم. برای تغییر این متن روی دکمه ویرایش کلیک کنید.
69 Comments
Hey Guys,
Warning: From February 2024, all existing email autoresponders will become obsolete!
In fact, if you want to send marketing emails, promotional emails, or any other sort of emails starting in February 2024, you’ll need to comply with Gmail’s and Yahoo’s draconic new directives.
They require regular marketers like you and I to setup complex code on sending domains… and existing autoresponders like Aweber and GetResponse are not helping: they’re requesting you do all the work, and their training is filled with complex instructions and flowcharts…
How would you like to send unlimited emails at the push of a button all with done-for-you DMARC, DKIM, SPF, custom IPs and dedicated SMTP sending servers?
What I mean by all of that tech talk above, is that with ProfitMarc, we give you pre-set, pre-configured, DONE-FOR-YOU email sending addresses you can just load up and mail straight away.
We don’t even have any “setup tutorials” like other autoresponders either, because guess what: we already did all the setup for you!
All of our built-in sending addresses and servers are already pre-warmed with Gmail and Yahoo and they’re loving us: 99% inbox rate is the average!
⇒ Grab your copy here! ⇒ https://ext-opp.com/ProfitMarc
Hey,
The moment we’ve all been waiting for is finally here – GoBuildr is now LIVE! 🎉
🌐 Create ultra-lightning-fast websites, sales funnels, eCommerce stores, and more in less than 60 seconds, with just a keyword!
🚀 Say goodbye to the limitations of traditional page builders. GoBuildr combines the functionality of 16 different tools into one powerful app, supercharged with AI-assisted technology.
⇒ Click Here To Checkout Demo https://ext-opp.com/GoBuildr
Hey,
The moment we’ve all been waiting for is finally here – GoBuildr is now LIVE! 🎉
🌐 Create ultra-lightning-fast websites, sales funnels, eCommerce stores, and more in less than 60 seconds, with just a keyword!
🚀 Say goodbye to the limitations of traditional page builders. GoBuildr combines the functionality of 16 different tools into one powerful app, supercharged with AI-assisted technology.
⇒ Click Here To Checkout Demo https://ext-opp.com/GoBuildr
Hey,
The moment we’ve all been waiting for is finally here – GoBuildr is now LIVE! 🎉
🌐 Create ultra-lightning-fast websites, sales funnels, eCommerce stores, and more in less than 60 seconds, with just a keyword!
🚀 Say goodbye to the limitations of traditional page builders. GoBuildr combines the functionality of 16 different tools into one powerful app, supercharged with AI-assisted technology.
⇒ Click Here To Checkout Demo https://ext-opp.com/GoBuildr
Hey,
The moment we’ve all been waiting for is finally here – GoBuildr is now LIVE! 🎉
🌐 Create ultra-lightning-fast websites, sales funnels, eCommerce stores, and more in less than 60 seconds, with just a keyword!
🚀 Say goodbye to the limitations of traditional page builders. GoBuildr combines the functionality of 16 different tools into one powerful app, supercharged with AI-assisted technology.
⇒ Click Here To Checkout Demo https://ext-opp.com/GoBuildr
He Got 256,354 Free Views With AI…
Can you believe it?
People spend thousands of dollars to get that kind of result…
My friend Kundan just did it for free…
He only used his new app… AI ScreenSnap…
It’s the world’s first AI app that can generate videos with the power of Video-Exclusive AI Engine…
That can edit, record, and generate videos with just a few clicks… with zero experience…
Click here now and watch AI ScreenSnap in action https://ext-opp.com/AIScreenSnap
[Hot] AI Turns Any Photo, URL or Keyword into “Talking Head” Videos – https://ext-opp.com/AiTalkie
A.I Create & Sell Unlimited Audiobooks to 2.3 Million Users – https://ext-opp.com/ECCO
A.I Create & Sell Unlimited Audiobooks to 2.3 Million Users – https://ext-opp.com/ECCO
Create Stunning Ebooks In 60 Seconds – https://ext-opp.com/AIEbookPal
Elevate Learning Adventures with The Story Shack!
A library of 200+ high-quality books tailored to the school curriculum.
StoryShack’s Build a Book bundle features word searches, quizzes, creative coloring pages, high-quality images, and top SEO keywords.
StoryShack’s StoryCraft Pro bundle includes the “Melody Minds Library” with 350+ music tracks and “AnimateMasters Pro,” offering 30+ categories of animations.
And as if that’s not enough, here are the MEGA BONUSES:
✔ 100+ Mega Mazes Pack
✔ 100+ Sudoku Elements Pack
✔ 100+ Comic Book Template Pack
✔ 100+ Handwriting Practice Template Pack
✔ 100+ Kids Story Book Templates
✔ Canva Book Templates
✔ Additional beautiful content like journal prompts
✔ INCLUDED: The Ultimate Workbook
Click https://ext-opp.com/StoryShack to explore The Story Shack e-Learning Collection and seize the opportunity for multiplied income!
Elevate Learning Adventures with The Story Shack!
A library of 200+ high-quality books tailored to the school curriculum.
StoryShack’s Build a Book bundle features word searches, quizzes, creative coloring pages, high-quality images, and top SEO keywords.
StoryShack’s StoryCraft Pro bundle includes the “Melody Minds Library” with 350+ music tracks and “AnimateMasters Pro,” offering 30+ categories of animations.
And as if that’s not enough, here are the MEGA BONUSES:
✔ 100+ Mega Mazes Pack
✔ 100+ Sudoku Elements Pack
✔ 100+ Comic Book Template Pack
✔ 100+ Handwriting Practice Template Pack
✔ 100+ Kids Story Book Templates
✔ Canva Book Templates
✔ Additional beautiful content like journal prompts
✔ INCLUDED: The Ultimate Workbook
Click https://ext-opp.com/StoryShack to explore The Story Shack e-Learning Collection and seize the opportunity for multiplied income!
Millions of Free Traffic with AI Tools – https://ext-opp.com/AIVault
After Generating Millions Online, I’ve Created A Foolproof Money Making System, & For a Limited Time You Get It For FREE… https://ext-opp.com/RPM
ChatGPT powered Autoresponder with Free SMTP at Unbeatable 1-Time Price! https://ext-opp.com/NewsMailer
An Ultimate Web-Hosting Solution For Business Owners https://ext-opp.com/HostsMaster
An Ultimate Web-Hosting Solution For Business Owners https://ext-opp.com/HostsMaster
MobiApp AI – True Android & iOS Mobile Apps Builder (Zero Coding Required) https://ext-opp.com/MobiAppAI
MobiApp AI – True Android & iOS Mobile Apps Builder (Zero Coding Required) https://ext-opp.com/MobiAppAI
Word’s First NLP & ML Based Email, Voice & Video Marketing Autoresponder Thats Boost Email Delivery, Click & Open Rates Instantly https://ext-opp.com/VidMailsAI
Word’s First NLP & ML Based Email, Voice & Video Marketing Autoresponder Thats Boost Email Delivery, Click & Open Rates Instantly https://ext-opp.com/VidMailsAI
Word’s First NLP & ML Based Email, Voice & Video Marketing Autoresponder Thats Boost Email Delivery, Click & Open Rates Instantly https://ext-opp.com/VidMailsAI
Word’s First NLP & ML Based Email, Voice & Video Marketing Autoresponder Thats Boost Email Delivery, Click & Open Rates Instantly https://ext-opp.com/VidMailsAI
Word’s First NLP & ML Based Email, Voice & Video Marketing Autoresponder Thats Boost Email Delivery, Click & Open Rates Instantly https://ext-opp.com/VidMailsAI
Hey, did you know there are app that mass generate hundreds of redirects to your link from different domains? Get it here – https://ext-opp.com/BUS
Hey, did you know there are app that mass generate hundreds of redirects to your link from different domains? Get it here – https://ext-opp.com/BUS
Are you still using Calendly to schedule your calls and meetings?
If your answer is yes, then you are actually hurting your business not helping it…
Calendly is limited, doesn’t unlock the full potential of your business…
And to make matters worse, they charge you monthly…
What a joke…
But you don’t have to worry, because my good friend Kundan is about to change the entire market …
You see, he just launched his newest creation AI Calenderfly…
The world’s first appointment-setting app that is fully powered by AI…
It will do all of the heavy lifting for you on complete autopilot…
AI meeting scheduling
AI reminders
AI tracking
And much much more
You can even accept payments live, and collect leads…
But it gets even better…
You don’t have to pay a penny in monthly fees…
Click here to watch AI Calenderfly in action and secure your copy at the lowest price possible… https://ext-opp.com/AICalendarfly
mexican rx online: mexican online pharmacy – mexican drugstore online
pharmacies in mexico that ship to usa
http://cmqpharma.com/# mexico pharmacies prescription drugs
mexican mail order pharmacies
Rattling fantastic info can be found on web site.Expand blog
canadian pharmacy no scripts: canada cloud pharmacy – canada cloud pharmacy
buy canadian drugs: global pharmacy canada – canada drug pharmacy
purple pharmacy mexico price list [url=https://foruspharma.com/#]reputable mexican pharmacies online[/url] п»їbest mexican online pharmacies
reputable indian online pharmacy: buy prescription drugs from india – top 10 online pharmacy in india
mexican rx online: mexican drugstore online – mexican pharmaceuticals online
http://foruspharma.com/# medicine in mexico pharmacies
pet meds without vet prescription canada [url=https://canadapharmast.com/#]canadian pharmacies online[/url] my canadian pharmacy
mexican online pharmacies prescription drugs: medicine in mexico pharmacies – buying prescription drugs in mexico
п»їbest mexican online pharmacies: reputable mexican pharmacies online – pharmacies in mexico that ship to usa
mexico pharmacies prescription drugs: mexican mail order pharmacies – mexican mail order pharmacies
https://canadapharmast.online/# legitimate canadian mail order pharmacy
canadian pharmacy world: canadian mail order pharmacy – canadian pharmacy king reviews
medicine in mexico pharmacies: buying prescription drugs in mexico online – mexico drug stores pharmacies
mexico drug stores pharmacies: mexico drug stores pharmacies – mexican pharmacy
mail order pharmacy india: top 10 online pharmacy in india – top 10 online pharmacy in india
http://ciprodelivery.pro/# cipro pharmacy
http://clomiddelivery.pro/# how to buy generic clomid online
cipro online no prescription in the usa [url=http://ciprodelivery.pro/#]buy ciprofloxacin[/url] buy cipro cheap
where buy clomid without a prescription: can i order generic clomid price – can you get clomid no prescription
https://ciprodelivery.pro/# п»їcipro generic
https://clomiddelivery.pro/# where to buy generic clomid without insurance
paxlovid pharmacy [url=http://paxloviddelivery.pro/#]paxlovid cost without insurance[/url] paxlovid pill
buy cipro: buy cipro cheap – buy cipro online without prescription
https://ciprodelivery.pro/# where can i buy cipro online
http://paxloviddelivery.pro/# paxlovid pill
discount doxycycline [url=https://doxycyclinedelivery.pro/#]order doxycycline without prescription[/url] vibramycin doxycycline
http://amoxildelivery.pro/# azithromycin amoxicillin
how can i get generic clomid without insurance: cost generic clomid – can i get generic clomid price
http://paxloviddelivery.pro/# paxlovid price
ciprofloxacin mail online [url=http://ciprodelivery.pro/#]cipro pharmacy[/url] buy cipro online
http://amoxildelivery.pro/# amoxicillin 30 capsules price
http://paxloviddelivery.pro/# buy paxlovid online
where to buy cheap clomid no prescription [url=https://clomiddelivery.pro/#]order clomid tablets[/url] buying clomid without rx
buy cipro online usa: ciprofloxacin mail online – cipro 500mg best prices
http://clomiddelivery.pro/# where to get clomid
http://ciprodelivery.pro/# ciprofloxacin 500 mg tablet price
http://doxycyclinedelivery.pro/# doxycycline 75 mg tablet
paxlovid buy [url=https://paxloviddelivery.pro/#]paxlovid pharmacy[/url] paxlovid cost without insurance
Paxlovid buy online: paxlovid india – Paxlovid buy online
https://clomiddelivery.pro/# get cheap clomid
https://clomiddelivery.pro/# order cheap clomid without prescription
buy cheap amoxicillin [url=https://amoxildelivery.pro/#]where can i get amoxicillin[/url] buy amoxicillin online uk
http://ciprodelivery.pro/# ciprofloxacin 500mg buy online
doxycycline online cheap: 631311 doxycycline – doxycycline 7.5 mg
http://ciprodelivery.pro/# cipro
purchase cipro [url=https://ciprodelivery.pro/#]buy cipro online without prescription[/url] buy cipro cheap
ciprofloxacin over the counter: buy cipro online – cipro ciprofloxacin