Forum Discussion
excel calculation error
Hi I have been using excel for years and never encountered this problem A simple calculation that will just not work? You can see the numbers are correct and will calculate in a cell directly b...
Thanks
I am going to add a new post showing another problem
I am going to add a new post showing another problem
- I believe the problem may be connected with the fact that I exported a csv file from another program and then used the data on the sheet for some calculations Even after I saved the file as a workbook .xls the problem persists.
For example two numbers £24,86 and -£20 wen added show as £4860.
Nothing I do in the format options will change that and it defaults to "Custom" even after i select "Currency"
I have a screen shot which I will try to attach not sure if I can do that.
is it possible that using a CSV file could alter the excel settings?
regards