HDTutorial
EN
How to Convert Text to Numbers in Excel (5 Ways!)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Convert Text to Numbers in Excel (5 Ways!)

375,040 views November 15, 2019 8:02

Watch on YouTube
ChannelPresentation Process

Chapters

Description from the creator

How to Convert Text to Numbers in Excel - learn how to correct this very common Excel issue with 5 different methods. Such issues usually occur when you copy numbers from another type of document (Word or Notepad etc.)
Link to Free Excel Mini-Course: presentation-process.com/mini-course-top-10-exc…
What is covered in this Excel tutorial:
==============
00:00 Text Vs Numbers Format in Excel
01:31 Number Test
02:09 5 Ways to Convert Text to Nos
02:25 How to Use Smart Tags
02:51 How to use the Text to Columns feature
03:38 How to use Paste Special option
04:14 How to use Value function
04:41 How to use Replace comma

Sign Up for Complete Excel Foundation Course:
shop.presentation-process.com/p/complete-excel-…

#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.

About this tutorial

Presentation Process published this 8:02 video tutorial on November 15, 2019. It has been watched 375,040 times on YouTube.

Duration
8:02
Published
November 15, 2019
Views
375,040
Likes
4,048

Tags

Share

This tutorial in other languages