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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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,538
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,660
Messages
5,549,278
Members
410,907
Latest member
Gan_77
Top