View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Josh925 Josh925 is offline
external usenet poster
 
Posts: 1
Default Saving Cell Format

I am creating a database in excel to combine with another database in another
program. To make these databases match, I need to format a column as a "text
field" though the information in the column is numbers. I am able to
highlight and change the column to text, but when I save the excel sheet as a
database, close and reopen the document, it automatically reverts to
"numerical field" format. How can I save the excel sheet as a Database file
and keep the column formatted as "numerical fields?"