Number format to Text

S

Sandy Burgess

I have had this problem numerous times. I have an excel file with a column
in a number format. I need to change the number format to text format for an
Access database. I have tried changing the excel format for the entire
column to text but the data still links to Access as a number format. How
can I change the excel file so Access will see the data as text?
 
P

Pimamedic

HAve you treid Data>text to columns follow the instructions to save numbers
as text
 
S

Sandy Burgess

Tried it - it didn't work. Data still linked to Access in a number format.
Thanks for replying.
 

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

Need help with converting CUSTOM format/TEXT format to DATE format 6
Excel Change Excel Text colour from Formula Bar 0
Date format diplays incorrectly 1
Format a column wihtout using "Format-Cells-Number-category-etc" 4
Convert Number to Text for Index/Match 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
text format to date format ? 1
Re-format cell to a number 4

Top