In process of converting Quatrapro files to Excel 2007. There appears to be
no direct conversion for QPW files in Excel so I save the WP file as an Excel
v7 (later version gives other problems). Works ok as imported into Excel
with one problem. The first column in the WP spreadsheet is the date in
12/1/08 (one of many rows). The file imported into Excel shows "#######" and
when the cell is selected, it shows in the formula bar: 12/1/2008 12:00:00 p.
Looks like Excel interprets this as a formula. How can I essentially, change
the cell to a date eliminating the entry as a formula. Each file contains
around 1400 such rows and I have nearly 120 files!