How to convert Numbers to text

C

Calif_guy

Hi everyone,
I know how to convert a text to number..... there are many tips on
this.
But I need to convert numbers to text so that I can import the sheet
to Access

I have a column with many many zip codes. Some have been entered are
numbers, and the vast majority are texts.

Any help would be great....

Thanks
 
J

JulieD

Hi

you can use the =TEXT function if there is a consistent format to your
numbers,
e.g. if all the numbers are five digits long then
=TEXT(A1,"00000")
and filled down will give you text for each of these numbers - you can then
copy this column, choose edit / paste special - values to change the formula
into values.

Cheers
JulieD
 

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

Similar Threads

Convert Numbers to Text 2
CONVERTING NUMBERS TO TEXT 6
Text to Number format 5
How do i convert dates to text but keep the date format 1
text as number 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Convert Number to Text for Index/Match 1
text converts to scientific 1

Top