Convert Numerical Text To Numbers

Typically when you are entering in a phone number for example, you will place an apostrphe (') in front of the data to label it as numerical text. You may do this for other numerical data such as social security numbers, and more. However, what if you want to turn some of that numerical text into numerics. Follow these steps:


The data will now be numeric where you can perform mathematical functions on the converted data.

Tip comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 22 August 2001.