Does Anybody Know Anything About Excel

[2008bangkok]

Hi i have a quite a number of csv files that each have a column that needs to be totaled up, my problem is that the autosum seems to n=be showing the incorrect total and from what i understand this is because it is in csv format.. i have saved as a excel work shhet but still the total shows the same?

Is there any excel gurus out there that can popin tme in the direction of a solution as ihave about 30 of them to do!

Cheers for now

[thaimite]

Hi i have a quite a number of csv files that each have a column that needs to be totaled up, my problem is that the autosum seems to n=be showing the incorrect total and from what i understand this is because it is in csv format.. i have saved as a excel work shhet but still the total shows the same?

Is there any excel gurus out there that can popin tme in the direction of a solution as ihave about 30 of them to do!

Cheers for now

Without seeing the data it is hard to say, but my guess is that some of the figures may have a leading space or some other character so that they are treated as text and not numbers.

One way this should show up is if those figures are left justified instead of right justified. It should have made no difference if the data was in CSV or XLS format.

Also try highlighting the column and setting the cell format to "number"

Hope this helps

[2008bangkok]

yeah iv tried that and still the same but thanks for advice..

Edited August 13, 2009 by 2008bangkok

[NanLaew]

There is an excel rounding error that I came across several years ago when doing a similar autosum of a column of numbers that were to the 3rd decimal place, ie. 1.234 I think the issue was if the 3rd number was a 7 as in 1.237 or 14.827 Whenever a seven was involved, the autosum was incorrect.

If you numbers are in similar format, try reducing the numbers to 2 decimal places by using the format cell, number. decimal places options and try the autosum again.

If all else fails, use a calculator for the summation like I did!

[ihightower]

yeah iv tried that and still the same but thanks for advice..

Once the csv file is open..

Highlight the column which you are to Sum... Then... Choose

Data -> Text To Columns

Then click.. next -> next ->

then in the Step 3 of 3.. .make sure General is clicked... then click finish.

now sum it.. it may work.

Anyway, if it doesn't...

I have 1000s of techniques up my sleeve... and I will be happy to help you for FREE!!!

because i will only know after seeing the excel file itself.

you can PM me.

[PornsakLim]

Hi i have a quite a number of csv files that each have a column that needs to be totaled up, my problem is that the autosum seems to n=be showing the incorrect total and from what i understand this is because it is in csv format.. i have saved as a excel work shhet but still the total shows the same?

Is there any excel gurus out there that can popin tme in the direction of a solution as ihave about 30 of them to do!

Cheers for now

To convert CSV file into Excel file, you have to be very careful about the cut-off of each column. Normally, they slipped and caused a problem.

Send me a file and I will tell you how.

Cheers,

Pornsak L

[Mercury]

Again, as per others, I'll happily look at the files. Self taught over 20 years at fair decent levels but it is all intuitive.

I have found similar things over time but it really is just speculation if you haven't got the file. If it is not sensitive, why not just host it somewhere or put it up here and we can have a look at it.

If you're trying yourself, start from adding 2 data fields. If they compute, then you have some rogue data but why is that not just being skipped ? Really, I'm not a tutor, I'm quite bad really, as I can't always explain how I go to where I am, just that the path is long.