Microsoft Office Forums - View Single Post - vlookup not working

Thread: vlookup not working

View Single Post

Old

08-10-2013, 05:24 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

a super easy way to convert a number formatted as text to a number is simply write this formula in an adjacent cell.
=a1+0
Then drag it down copy it and paste the values where you need it.

Reply With Quote