Cell Reformat
 

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!

Cell Reformat
 

I think everything is fine... I believe your column is not wide enough (if a
date doesn't fit in the width given it, Excel shows # signs). If you widen
the column wide enough, you will see your full date (and time). Just format
the column to show the portion of the date you want and then change the
width accordingly.

--
Rick (MVP - Excel)


"joe925c" wrote in message
...
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!

Cell Reformat
 

Rick,

Thanks for your suggestion. It worked! Just finished converting all my QP
files to Excel.

"Rick Rothstein" wrote:

I think everything is fine... I believe your column is not wide enough (if a
date doesn't fit in the width given it, Excel shows # signs). If you widen
the column wide enough, you will see your full date (and time). Just format
the column to show the portion of the date you want and then change the
width accordingly.

--
Rick (MVP - Excel)


"joe925c" wrote in message
...
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!