Won't paste text if first 5 records are numbers

[nigelbloomy]

I have a list of part numbers in Excel. The user needs to get them into Access so it can run the queries and get the data about all of the part numbers. The part number field in my form is formatted as text because the part numbers are alphanumeric. Right now the user copies the list of part numbers out of Excel and pastes them into my Access form. The problem is that if the first 5 part numbers are only numbers, then Access assumes the whole field can only be for numbers and all of the alphanumeric part numbers are pasted in as blanks. How can I stop this from happening? It works fine when one of the first 5 part numbers has a letter in it.

[June7]

Try defining the cells in Excel as Text instead of General format - works for me.

[nigelbloomy]

Works perfectly now. That was an easy fix. Thank you so much.