<div>
Yes, thats exactly what I meant. If you are confirming that we can export the result direct to a csv file, thats great!<br />
Many thanks.
</div>


Yes, thats exactly what I meant. If you are confirming that we can export the result direct to a csv file, thats great!
Many thanks.

<div>
You should be able to. Having saved as csv from Excel, you can always open it in Notepad just to check it looks OK.<br />
Regards,<br />
Rory
</div>


You should be able to. Having saved as csv from Excel, you can always open it in Notepad just to check it looks OK.
Regards,
Rory

<div>
Also, you can always use &nbsp;INT() around the formula to convert to an integer.<br />
<br />
I hope this helps !<br />

</div>


Also, you can always use  INT() around the formula to convert to an integer.

I hope this helps !


<div>
<div class="content wysiwyg-content">
We have a price list which is approximately 4000 lines long, opened in excel.<br />
We wish to carry out some minor formulea functions to determin a cost price.<br />
No problem so far, however, we wish to save the results into a column that will give an integer value, rather than a result calculated from a formula.<br />
The idea is that we can then import the fileds back into our stock file.<br />
I am presuming that if we try and import the resulting file back in to our accounts in the CSV format, the import will fail.<br />
Am I right, if so does anyone have any ideas how we can work around this?<br />

</div>
</div>


We have a price list which is approximately 4000 lines long, opened in excel.
We wish to carry out some minor formulea functions to determin a cost price.
No problem so far, however, we wish to save the results into a column that will give an integer value, rather than a result calculated from a formula.
The idea is that we can then import the fileds back into our stock file.
I am presuming that if we try and import the resulting file back in to our accounts in the CSV format, the import will fail.
Am I right, if so does anyone have any ideas how we can work around this?


Excel CSV formula problem.

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.