Excel CSV formula problem.

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?
Who is Participating?
Rory ArchibaldCommented:
What do you mean by "an integer value, rather than a result calculated from a formula"?
The csv file will contain the results of the formula, not the formula, if that's what you mean?
nigelbeatsonAuthor Commented:
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.
Rory ArchibaldCommented:
You should be able to. Having saved as csv from Excel, you can always open it in Notepad just to check it looks OK.
Also, you can always use  INT() around the formula to convert to an integer.

I hope this helps !
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.