Use the NUMBERVALUE Function to Convert Numbers that Appear as Text

Share this & earn $10
Doug H
Published at : 15 Oct 2021
15843 views
52
2

This video shows how to use a new function in 2013 - NUMBERVALUE. It converts text to a number. In some instances you may have currency numbers that are recognized as text in Excel. You need to convert this to a currency number that is recognized as a number (that Excel can perform calculations on) so the NUMBERVALUE function can do this.


🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel

#excel
#msexcel
#doughexcel

tutorialmsofficetrain101excel 2013

Learn CONTINUOUS TENSES in English the EASY way!

Learn CONTINUOUS TENSES in English the EASY way!

IC3PEAK - You Agree

IC3PEAK - You Agree

The Many Uses of The Ultimate Survival Vegetable

The Many Uses of The Ultimate Survival Vegetable

When to use DON'T and DOESN'T  🤔  | Easy Explanation

When to use DON'T and DOESN'T 🤔 | Easy Explanation

Math Antics - Proportions

Math Antics - Proportions

Benjai - Phenomenal (Official Music Video) "2015 Soca" [HD]

Benjai - Phenomenal (Official Music Video) "2015 Soca" [HD]

Mokey's Show - Is Not Christmas

Mokey's Show - Is Not Christmas

Touch | Sleeping At Last

Touch | Sleeping At Last

Foods That Originally Looked Totally Different

Foods That Originally Looked Totally Different

Refilling and Organizing Tiktoks | Tiktokato Compilation

Refilling and Organizing Tiktoks | Tiktokato Compilation

The US Empire and dollar will not last forever – Ron Paul on Pentagon findings

The US Empire and dollar will not last forever – Ron Paul on Pentagon findings

Amanda Has Five Years Left if She Doesn't Lose Weight | Fat Doctor | Only Human

Amanda Has Five Years Left if She Doesn't Lose Weight | Fat Doctor | Only Human

Marilyn Monroe. Beautiful and Delicate..

Marilyn Monroe. Beautiful and Delicate..

AYI GROUP "Now your digital transformation is simpler"

AYI GROUP "Now your digital transformation is simpler"

An Important Case - Stage 4 Oxford Reading Tree

An Important Case - Stage 4 Oxford Reading Tree

Seth Rollins talks WrestleMania 31 backstage ahead of cash-in on Roman Reigns & Brock Lesnar

Seth Rollins talks WrestleMania 31 backstage ahead of cash-in on Roman Reigns & Brock Lesnar

ORDINARY (Little Miss Perfect Sequel) lyric video

ORDINARY (Little Miss Perfect Sequel) lyric video

Police Takedown Fails & Car Chases #88 - BeamNG Drive | CRASHdriven

Police Takedown Fails & Car Chases #88 - BeamNG Drive | CRASHdriven

Big Nose's Picks! | 56 Minute Pink Panther and Pals Compilation

Big Nose's Picks! | 56 Minute Pink Panther and Pals Compilation

Kid CuDi Simple As

Kid CuDi Simple As

Doja Cat - Addiction (Audio)

Doja Cat - Addiction (Audio)

Greg Laswell - Comes and Goes

Greg Laswell - Comes and Goes

WE FINALLY BEAT THIS CURSED GAME!!11!! | Night of the Consumers (ENDING)

WE FINALLY BEAT THIS CURSED GAME!!11!! | Night of the Consumers (ENDING)

marc indigo - accountable 😔

marc indigo - accountable 😔

Little Car Blue: 2018 Smart Fortwo Gets a 10th-Anniversary Edition

Little Car Blue: 2018 Smart Fortwo Gets a 10th-Anniversary Edition

What is roofed forest - Minecraft

What is roofed forest - Minecraft

Cloudchord & Supersillyus - Emblem

Cloudchord & Supersillyus - Emblem

Yung Bans - Dresser (Directed by Cole Bennett)

Yung Bans - Dresser (Directed by Cole Bennett)

What is a Government?

What is a Government?

Is Defense simply too weak in Guilty Gear Strive?

Is Defense simply too weak in Guilty Gear Strive?

Ty Dolla $ign & Wiz Khalifa - Brand New [Official Video]

Ty Dolla $ign & Wiz Khalifa - Brand New [Official Video]

In a Relationship | Tawsif Mahbub | Sabila Nur | Mehedi Hassan Hridoy | Bangla Natok 2020

In a Relationship | Tawsif Mahbub | Sabila Nur | Mehedi Hassan Hridoy | Bangla Natok 2020

Basics of Buying & Selling a Property

Basics of Buying & Selling a Property

The Power Of Anticipation: How To Handle Problems Before They Arise

The Power Of Anticipation: How To Handle Problems Before They Arise

Disregard - Sacrifice (Guitar Playthrough)

Disregard - Sacrifice (Guitar Playthrough)

Alec Benjamin - Let Me Down Slowly (Lyrics)

Alec Benjamin - Let Me Down Slowly (Lyrics)

The Same Persons - Versace [NCS Release]

The Same Persons - Versace [NCS Release]

China Made An Artificial Star 6 Times Hotter Than The Sun

China Made An Artificial Star 6 Times Hotter Than The Sun

Remoted (Original Mix)

Remoted (Original Mix)

We Got The Mysterious Last Crystal Before They Could! The Visitors (File 25)

We Got The Mysterious Last Crystal Before They Could! The Visitors (File 25)

ΕΛΛΗΝΟΤΟΥΡΚΙΚΑ | Έρχονται αμερικανικά ελικόπτερα - (28.10.2021)[Eng subs]

ΕΛΛΗΝΟΤΟΥΡΚΙΚΑ | Έρχονται αμερικανικά ελικόπτερα - (28.10.2021)[Eng subs]

Book haul, book mail & a week of adventures 🍂 reading vlog

Book haul, book mail & a week of adventures 🍂 reading vlog

Mike Baynham: Identity brought about or brought along?

Mike Baynham: Identity brought about or brought along?

Why “snot” is crucial for your health | Ep174

Why “snot” is crucial for your health | Ep174

Get Back (Remastered 2009)

Get Back (Remastered 2009)

10 Best Intelligence Agencies in the World

10 Best Intelligence Agencies in the World

Sam Hunt - Take Your Time (Official Music Video)

Sam Hunt - Take Your Time (Official Music Video)

“My Own Home” -Jungle Book (LIVE version)

“My Own Home” -Jungle Book (LIVE version)

Learn English through story -The Citadel -Advanced Level

Learn English through story -The Citadel -Advanced Level