View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Burgess Sandy Burgess is offline
external usenet poster
 
Posts: 4
Default 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