[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 748
  • Last Modified:

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?
0
nigelbeatson
Asked:
nigelbeatson
  • 2
1 Solution
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now