Archive of Mr Excel Message Board

Back to Lotus archive index
Back to archive home

problems converting .rpt format to .xls format

Posted by David Hoyt on January 26, 2001 6:05 AM

I am using a database reporter called ReportSmith. When I convert the report to Excel all the numbers are saved as text. I have tried to change to a number using the format cell but it don't work. The only way I have found that works is by editing each cell by hitting "F2" and then "enter". This takes a long time as you can guess. What is the best way to convert a text cell to a number cell?

Re: problems converting .rpt format to .xls format

Posted by Mark W. on January 26, 2001 6:18 AM

I'm not familiar with ReportSmith, but I trust that
the report it creates is a .txt file. If so, you
can open the report file from within Excel using
the File Open... command. This will invoke the Text
to Column wizard which will allow you to format
columns at will.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.