Excel CSV formula problem.
Posted on 2007-07-31
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?