<div>
DaveF,<br />
<br />
Have you tried opening a Lotus file in Excel and then saving it as an Excel workbook manually instead of using the Wizard.<br />
<br />
If it works that way and there are a lot of files, I could write a macro that would process a batch of files (I think).<br />
<br />
Let me know if it works manually or not.<br />
<br />
Steve<br />

</div>


DaveF,

Have you tried opening a Lotus file in Excel and then saving it as an Excel workbook manually instead of using the Wizard.

If it works that way and there are a lot of files, I could write a macro that would process a batch of files (I think).

Let me know if it works manually or not.

Steve


<div>
Shalbe<br />
<br />
Unfortunately I have already tried this, as soon as you open the file in Excel the roundup &amp;&nbsp;rounddown formulas are replaced with values. &nbsp;An error message is displayed as the file is opened, to the effect that 898 cells could not be processed. (I assume these are the roundup / rounddown cells)<br />
<br />
Cheers<br />
Dave<br />

</div>


Shalbe

Unfortunately I have already tried this, as soon as you open the file in Excel the roundup & rounddown formulas are replaced with values.  An error message is displayed as the file is opened, to the effect that 898 cells could not be processed. (I assume these are the roundup / rounddown cells)

Cheers
Dave


<div>
<div class="content wysiwyg-content">
I have changed a number of .wk4 files to .xls (XL97) format for use at work. &nbsp;However the Lotus files use the @roundup and @rounddown command. &nbsp;The new Excel file did not convert these it simply pasted the values in.<br />
<br />
However the wizard reported a successful conversion. &nbsp;I know equivalent commands exist in XL97, can I get the command to work on conversion.<br />
<br />
The files are 12meg each and I do not really want to input all the roundup &amp;&nbsp;round down fuctions again, it could take a couple of days.
</div>
</div>


I have changed a number of .wk4 files to .xls (XL97) format for use at work.  However the Lotus files use the @roundup and @rounddown command.  The new Excel file did not convert these it simply pasted the values in.

However the wizard reported a successful conversion.  I know equivalent commands exist in XL97, can I get the command to work on conversion.

The files are 12meg each and I do not really want to input all the roundup & round down fuctions again, it could take a couple of days.

Lotus -&gt; Excel : @roundup command

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Lotus -&gt; Excel : @roundup command

Lotus -> Excel : @roundup command