Proper way to convert numbers to text

G

Guest

I have recieved a spreadsheet from an individual, and in the column it has
mixed data types. Some of the entries are pure numbers such as 0300559100,
but some are numbers with a alpha character in it such as 0300A59263.

What is the proper way to format the column? It needs to be in text format,
not numeric. The reason, is that when I will inport it into Access, it
cannot handle mixed data types in the same column (field).

I've heard that you shouldn't format a column unless you have to. What
about putting a ' character in front of all of the numbers? If that is the
way to go, what is the quickest way in insert that ' character in each entry?

TIA for your answers.

Phil.
 
S

Sam

why wouldnt you format the column as text? - thats exactly the way to
go to map to a text field in access
 
G

Guest

Tried that. Does NOT work. I could send the file in question, but don't know
where or how.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top