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?
LVL 1
nigelbeatsonAsked:
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?
Regards,
Rory
0
 
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.
0
 
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.
Regards,
Rory
0
 
SysExpertCommented:
Also, you can always use  INT() around the formula to convert to an integer.

I hope this helps !
0
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.