How to easily convert data to number

ExcelPupper

Board Regular
Joined
Mar 2, 2020
Messages
101
Office Version
  1. 2019
Platform
  1. Windows
Hi. I have here a sample set of data exported from a MS Access database. My current problem is that it takes time to convert these data to numbers because normally it contains thousands of row. I just want to ask if there's an easier way aside from clicking the yellow sign then click convert to number? Many thanks
1601446001197.png
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,409
Office Version
  1. 2013
Platform
  1. Windows
Highlight the column , then run this macro
VBA Code:
Sub MM1()
Dim c As Range
For Each c In Selection
c.Value = c.Value * 1
Next c
End Sub
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,520
Office Version
  1. 365
Platform
  1. Windows
You can select all the data from B2 down & then click the ! mark to convert the entire data, or you can use text to columns.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,651
Messages
5,549,204
Members
410,905
Latest member
Extjel
Top