Number format to Text
 

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?
--
Sandy Burgess

Number format to Text
 

HAve you treid Datatext to columns follow the instructions to save numbers
as text

"Sandy Burgess" wrote:

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?
--
Sandy Burgess

Number format to Text
 

Hi,

In a spare column, use the formula A2&"" to convert to text.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sandy Burgess" wrote in message
...
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?
--
Sandy Burgess

Number format to Text
 

This worked perfectly. Thank you!
--
Sandy Burgess


"Pimamedic" wrote:

HAve you treid Datatext to columns follow the instructions to save numbers
as text

"Sandy Burgess" wrote:

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?
--
Sandy Burgess

Number format to Text
 

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


"Ashish Mathur" wrote:

Hi,

In a spare column, use the formula A2&"" to convert to text.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sandy Burgess" wrote in message
...
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?
--
Sandy Burgess