Excel tip 2: Convert text to number with paste special

When working with a large data set exported from an ERP system we often need to convert numbers stored as text to numbers. This can be done the traditional way by following Excels error indicator or much faster with the paste special technique you see in this video.