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?"
|